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
If you're using an ODBC driver, you need to make sure that the ODBC driver you selected is for 64-bit. The 64 bit access installation that you added is for ADO connections that use the JET database driver.
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
