Installation of Advantage ODBC 64bit driver

Question

After installing the V10 64-bit driver from here http://devzone.advantagedatabase.com/dz/content.aspx?key=20&Release=15 on 64bit Windows 7 Professional and trying to connect I get the following error messge:

"ODBC -call failed [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (#0)"

When I click "Check DLLs" I get an error message saying that the following DLLs were not found adsodbc.dll

I have tried uninstall, re-install, the adsodbc.dll file is not on the computer anywhere but there is a file called adsodbc64.dll I have tried copying and renaming this with no success.

Any ideas please?

Thanks

Ian

Answer 1

I think, the problem is that Windows7 x64 supports only 32bit ODBC drivers. Checkout MSDN

Answer 2

I believe the "Check DLLs" message is in error and a red haring in regards to the base issue. I too have a similar setup and see that it is looking for the adsodbc.dll rather then adsodbc64.dll. But in my situation I am able to connect.

The error message you get is often due to a mistype of the name (i.e. mydsn123 vs mydsn23).

It may also be due to the application attempting to use the ODBC driver. For example, is the application attempting to use the ODBC driver actually a 32-bit application that would be looking for a 32-bit ODBC DSN using C:\Windows\SysWOW64\odbcad32.exe rather then the 64-bit c:\windows\system32\odbcad32.exe... Names are confusing here, where the system32 = 64-bit and syswow64 = 32-bit.