Linked Server problem

[moonoi]

I executed dbo.cabal_sp_newchar but I got this error

OLE DB provider "MSDASQL" for linked server "GAMESERVER" returned message "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).".
OLE DB provider "MSDASQL" for linked server "GAMESERVER" returned message "[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.".
Msg 7303, Level 16, State 1, Procedure cabal_sp_newchar, Line 27
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "GAMESERVER".

Linked Server has been created

You must be registered to see links

 

[xz3r0x]

u didnt enter user name and password of your sql user, in in UID and PWD in connection string
i made i guide abaout creating a user and linked gameserver, but in sql 2000
http://forum.ragezone.com/showthread.php?t=432469
have a look