ODBC problems

[hencyt]

We have SQL server 7. For our accounting application I have several ODBC setup that access different databases. WHen I go to ODBC setup- all the ODBC still appear to be there- but when you try to configure any of them it gives an error that it is not an existing data source name. That error is followed by Invalid DSN error. If I try to delete and recreate them, I get the same errors. It will allow me to make a new ODBC, but not with the same name as any existing ones.

Please help!

Sunny

 

[hencyt]

May be helpful to know workstation OS is XP.

Also- maybe someone can just tell me what files are related to odbc setup? Maybe I can rename and recreate them all?

Anyone?

Thanks,
Sunny

 

[SQLBill]

It sounds like your DSN got 'messed' up. Try to create an ODBC connection using the IP address instead of the computer/server name. If that works, then your DNS server is no longer doing Name Resolution. Check with your system/network admin if that's the problem.

-SQLBill