ODBC Mystery

[drexen1]

I am using a third party application that needs to connect to my Microsoft SQL Database. Everything I launch the application I receive this error message.

“Error in Microsoft Rdo.Connection” An ODBC Error has occurred:
08004: SQL Server Attempt to locate entry in Sysdatabases for database ‘dock03’ by name failed.

I have renamed one of my SQL databases from ‘dock03’ to ‘dock04’. For some reason something in ODBC is still looking for the old database name ‘dock03’

How and what do I need to change so that it is looking for the new database name ‘dock04’?

 

[nicsin]

Did you edited the ODBC when you changed the db name? If not you have to go to (win2k) start -> settings -> control panel -> administrative tools -> data sources (odbc) and then find the ODBC used for the connection and click configure to reassign the database.

 

[drexen1]

I did not edit the ODBC after I changed the database name because I wasn’t sure which or if there was one setup for it. The strange thing is when I go into Data Sources to modify the ODBC connection, I only see the one default connection listed there (User & System DSN). So I am not sure where it is receiving its ODBC connection information from.

 

[nicsin]

It should be there... check all the DSNs in both user and system and even file to see which one is refering to the old name.