[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • 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
submarinerssbn731
Asked:
submarinerssbn731
  • 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
 
submarinerssbn731Author Commented:
Your assumptions were correct about the 64 bit system.  I followed your instructions and it worked like a charm.  Great Answer!  Thanks!!!
0
 
submarinerssbn731Author Commented:
Thanks!
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

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