Cannot Connect To SQL Server Using Working DSN

[mes5464]

I have a DSN that works just fine when I test it. When I try to connect with Access using the same DSN I get the following error:

[rpeare]

Are you able to link a table from the database in question into your database, open the table and see the contents just fine?

If so you may just have mistyped your DSN.

Also, is the DSN you're using a SYSTEM or USER DSN, that could make a difference as well.

Can you show the code you're using to connect to the database?

[mes5464]

I have a database with linked tables to the SQL Server through the DSN. I could open the tables before but now I cannot.
The DSN is perfect because I can open the ODBC manager and test the connection and it succeeds.
The DSN is a System DSN.
There is not code to show, these are simply linked tables.

[mes5464]

Ok. I found the answer.

There are two ODBC Data Source Administrators, they are located at:

• C:\Windows\SysWOW64\odbcad32.exe
• C:\Windows\System32\odbcad32.exe

If you go to: Start > Control Panel > Administrative Tools > Data Sources (ODBC)
You will get the odbcad32.exe found in C:\Windows\System32

If in Access 2013 (64 bit) you go to: External Data > ODBC Database
You will get the odbcad32.exe found in C:\Windows\SysWOW64

Neither of these ODBC Data Source Administrators shows you all of the DSN on your machine.
If you want to edit a DSN you created using Access (64 bit) you will have to launch
C:\Windows\SysWOW64\odbcad32.exe from the command line and there you will get the
option to edit the DSN created through Access.

I hope this saves someone else the pain I have gone through for two days.

[rpeare]

Ha yes I've run into this myself, particularly when dealing with different versions of MS access but I was going for the easy stuff first.