• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

ODBC Connection Failure Access 2003

I have a Access database that is used for collecting employee data.  This database is also updated from a SQL Server database via an update query in the Access database.  The SQL Server talbes are linked into the Access database.  When I attempt to run the update query I get "ODBC --- connection to TRUPAY failed.  TruPay being the SQL Server database.  What are the most logical causes of this problem.  Thanks.
0
Steve Eckerman
Asked:
Steve Eckerman
  • 2
2 Solutions
 
SmartAceW0LFCommented:
If this is on a Windows 7 machine with a 64 bit Operating System, my next question would be to ask if you have setup the 64 bit ODBC Drivers on the workstation you are connecting from.  Given that you are indeed trying to connect from a 64 bit workstation you will need to browse to your C:\Windows\SysWOW64\ folder and open odbcad32.exe file instead of opening the ODBC in Administrative Tools or Control Panel.  Once there you would link up all your tables and databases just as was previously done.  Good luck.
0
 
Steve EckermanSystems AdministratorAuthor Commented:
Your assumptions were correct about the 64 bit system.  I followed your instructions and it worked like a charm.  Great Answer!  Thanks!!!
0
 
Steve EckermanSystems AdministratorAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now