December 31, 2002 at 12:40 pm
I set up a linked server between 2 SQL2000 machines in our office and ran a query against server b from server a. No problem.
Then a tried to create a view in a specific database in server a that references server b. Big problem. Received the following error message.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'B\X' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
The linked server appears in Enterprise manager with the correct name in server a, so I believe the error message is bogus.
Can anyone help?
"I hope you enjoy your retirement as much as I will."
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
December 31, 2002 at 1:38 pm
Set up your query in QA. Such as:
Select fieldlist from remoteserver.remotedb.owner.table
Run it.
When it succeeds, place the Create View ViewName As above it in QA such as :
Create View ViewName As
Select fieldlist from remoteserver.remotedb.owner.table
Run it.
If the query executed, the view should create as well. Did it? Also, is your server actually named B\X?
January 2, 2003 at 10:56 am
The problem was caused by several linked processes "stuck" in the system. I rebooted the server to clear them and the problem was solved.
"I hope you enjoy your retirement as much as I will."
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply