My Linked server in sql not work

[DWBaHu0]

Hello,

When i go to New Linked Server and -> Provider: Microsoft OLE DB provider for ODBC DRIVERS and on "Provider string" there i cant do nothing i cant write a text.. how to fix that.. please help i am with sql 2005

 

[darnals]

im too but im on sql 2k.
i was try add linked server on query but doesn't work.
any have idea to solve this?

 

[omen]

use this provider string, and replace the "123456" with your mssql sa password.

DRIVER={SQL Server};SERVER=localhost;UID=sa;PWD=123456;

This works for sql 2000 and sql 2005

 

[majidemo]

i think its not really necessary to use the uid=sa;pwd=12345 if ur using 2k5 +!

 

[omen]

i think its not really necessary to use the uid=sa;pwd=12345 if ur using 2k5 +!

it doesn't matter at all what you think - because for all we know you may be a total moron.
try

DRIVER={SQL Server};SERVER=localhost;UID=sa;PWD=123456;

and reply to say if it worked or if it didn't.

 

[chumpywumpy]

DRIVER={SQL Server};SERVER=127.0.0.1;UID=;PWD=;

Replace 127.0.0.1 with the windows ip as using "localhost" won't work usually. The user and pass can be specified there but it can be left out as the server gets these from the server config files and specifies then in the DSN used to connect. I prefer to leave them out of the connection string.

Once you have added a linked server you can't edit it and you must delete it and recreate it from scratch.

 

[Devile]

I tried ALL possibilities and none worked for me. localhost with and without sa pass in the provider string, 127.0.0.1, the real ip, the server name, etc. Every single time I received "Unknown DB" errors.

Finally, what worked for me was "Be made using this security context" in the security tab. sa user and password for the "Remote Login" and "With password" fields.

MSSQL 2005. Dont ask me why but nothing else worked for me but that. Hope that helps.

 

[DWBaHu0]

in game when i try to create a character i have error: DB ERROR (just that)

but my providers.. notwork are.. "CLOSED" are somethings like that.. anyone know how to uninstall sql and i will install it again.. maybe will fix that Ducking problem

 

[chumpywumpy]

in game when i try to create a character i have error: DB ERROR (just that)

but my providers.. notwork are.. "CLOSED" are somethings like that.. anyone know how to uninstall sql and i will install it again.. maybe will fix that Ducking problem

That will probably be the linked server but you will need to check the logs to be absolutely sure. To uninstall just use the add/remove option in your control panel.

 

[darnals]

has i make a ODBC too?
Oh Yeah Sir Chumpy can u make a video how to fix it?
i think a video very helpfull.

 

[tboy1991]

i used this in mssql2005
make a new query window, paste this:

EXEC sp_addlinkedserver GAMESERVER

and Execute to the master table, it's worked for me

 

[john_d]

easy...

if ur using 2005 sql

use
1. SQL native
2. test it like this

in sql query

use gamedb;
select * from GAMESERVER.account.dbo.cabal_auth_table

if the query is successful.. ur LInk server is working. simple as that.

 

[DWBaHu0]

i fix this problem with linked server.. i reinstalling the windows.. but now i have other problem..
i have log error:
[##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[##ERROR##] DB ERROR(CODE) : 4060
[##ERROR##] DB ERROR(VAR_INFO) :
[##ERROR##] DB ERROR(SQLSTATE) : 42000
[##ERROR##] DB ERROR(STM_TEXT) :
[##ERROR##] Database Connect Fail (uid=;pwd=;dsn=CabalGame24;APP=DBAgent_24)
[##ERROR##] check 'pDB' fail
[##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(192.168.1.5)[/CODE]

and in game i have :
Cannot proceed with the command due to unknown DB errors. Please try again.

Can fix that ?

 

[tboy1991]

[##ERROR##] Database Connect Fail (uid=;pwd=;dsn=CabalGame24;APP=DBAgent_24)
so you are not configured the DBAgent

 

[john_d]

edit the two odbc.ini

and restart ur linux