Simple ODBC Connection Problem (MS Access / Windows 7)
Posted on 2012-08-14
I have very limited experience with setting up ODBC connections, but I'm hoping this is a simple problem to solve (I've set this at 500 points though as I need an answer within the next 12 hours please!).
I'm having a problem getting my Access 2010 database to find a 64bit ODBC connection on a Windows 7 machine. I've installed Sage 50 2012 (version 18) and ran the ODBC installation executable.
It appears that the latter created the DSN 'SageLine50v18'. I found this in the 64bit registry and also using the 64bit ODBC Administrator (%SystemRoot%\SysWow64\odbcad32.exe). It does not appear when I check with the 32bit ODBC Administrator (%SystemRoot%\system32\odbcad32.exe).
My database is using the following connection string:
however the connection fails.
This setup was working in MS Access 2000 on XP with Sage 50 2009 (Version 15) with the following connection string:
I'm guessing that I have to modify the connection string to find the DSN declared in the 64 bit registry, but how I would do this is beyond me. Am I on the right track or is there something else that I have to do?
Thanks for your help in advance.