Disconnect Error 0

07/17/2011 23:31 iykeusa#1

I have seen various solutions to this problem but i fink in my case it's a little different. The log file displays this

Code:

2011-07-17 19:16:08 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2011-07-17 19:16:08 ::LoadBillingItem 1  qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

I have no idea how i'm supposed to do this :S

07/18/2011 00:33 Bаne#2

Could not find server 'PS_USERDB01' in sys.servers. There is the probleme.

07/18/2011 08:20 iykeusa#3

Oh thank you, so how do i fix it?

07/19/2011 02:43 JohnHeatz#4

By reading the log you might've known it already...yet if that file is missing, you just need to add it manually to that location

07/19/2011 09:03 iykeusa#5

but i don't know what the file is or where i'm supposed to add it :S

07/19/2011 21:43 JohnHeatz#6

Quote:

Originally Posted by iykeusa

Code:

2011-07-17 19:16:08 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server [B]'PS_USERDB01' in sys.servers.[/B] Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

As it is on bold on your code thing quoting.....the file is PS_USERDB01 and it should be on sys.servers

12/31/2011 21:12 tushar159753#7

Quote:

Originally Posted by iykeusa

but i don't know what the file is or where i'm supposed to add it :S

ive got the same thing...