We help IT Professionals succeed at work.
Get Started

Simple ODBC Connection Problem (MS Access / Windows 7)

5,540 Views
Last Modified: 2012-08-16
Hi Experts,

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:
"ODBC;dsn=SageLine50v18;uid=MANAGER;pwd=;"
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:
"ODBC;dsn=SageLine50v15;uid=MANAGER;pwd=;"

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.

Oliver
Comment
Watch Question
Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This problem has been solved!
Unlock 3 Answers and 8 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE