You need to make sure, then, that in your connection string, you're referencing the 64-bit ODBC driver... I'm assuming it has a slightly different name. Do that, and you can use the 64-bit TestComplete
Thanks for your reply. Is it about - Office System Driver: Data Connectivity Components
https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734
Tried this as well, didn't help.
If not, would it be possible for you to share the driver download link please?
I can search for it, just want to be sure that I am not doing anything wrong.
No, I don't think that's it. That's the same data access components mentioned in the previous article.
In your OS, you should have ODBC data sources for both 64-bit and 32-bit. You're using the one for 32-bit in the 64-bit TestComplete. That's why you're getting the problem.
Note, however, that you don't HAVE to run your tests in 64-bit. TestComplete works, functionally, exactly the same regardless of bitness. If you can't find the proper ODBC data source to use, you should be fine running as 32-bit.
Got you, its about the system ODBC Data Source Administrator.
Yes, I have added the Microsoft Excel Driver under both User DSN / System DSN - in both 32bit ODBC and 64bit ODBC.
We are able to work along with 32bit TC, just trying to resolve this outstanding issue as we got some free time :) Thanks for your help tristaanogre
You need to make sure, then, that in your connection string, you're referencing the 64-bit ODBC driver... I'm assuming it has a slightly different name. Do that, and you can use the 64-bit TestComplete
You are absolutely right. Have not noticed that till now, just updated the connection string
from
"DRIVER={Microsoft Excel Driver (*.xls)};"
to
"DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};" and it worked.
I have no idea how the previous one worked all these days when the actual name in the ODBC is
"Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)"
Even now the old previous connection string works for TC 32bit.
Anyway thanks a lot tristaanogre
