I am extremely puzzled at what is going on with our SQL Server.
We set up an ODBC data source to connect on our SQL2000 server to point to another SQL2000 server in a remote location. This has worked now for the last 3 years until the SQL Server that the ODBC was pointing to was upgrated from SQL2000 to SQL2005.
Suddenly, the connection is broken.
I went to the ODBC data source and tested the connection and it says, "Connection was successful".
However, when I tested my code, I still get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
What could be wrong here!
Just to be sure I have covered all bases, here is the line on my code that is throwing this error:
riff01 is the dsn name.
Any help would be greatly appreciated.