Monday, March 12, 2012

Error ODBC SQL Server Driver

I am experiencing the following error in a server 2003 and SQL 2005 environment.
I don't know much about SQL, and any help would be appreciated. I have been told to look at the ODBC, as well as several items in SQL. But alas I have not been able to do much with it. Software program was purchased and support for the system is extremely limited.

Here is the error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'insert server name' in sysservers. Execute sp_addlinkedserver to add the server in sysservers.

I appreciate any help anyone has to offer.

It looks like you have to provide your application with the name of the server. I would guess that there is either a dialog with a template like "insert server name" where you are supposed to put a real server name, or a configuration file.|||

There is actually a server name that shows up in the error code, I just removed it for confidentiality. The name that appears is the correct name of the server.

|||

Have you tried following the instructions in the error message? It may be that the application assumes the servers are linked, and that you performed that step manually yourself. What happens if you link the servers?

No comments:

Post a Comment