Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

SQL Problem!Help!!

Newbie Spellweaver
Joined
Mar 1, 2007
Messages
10
Reaction score
0
How can I fix this pro?
Help me please!Thx!
 

Attachments

You must be registered for see attachments list
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
That is a problem with the linked server.



That may help but if not check your linked server settings. If you open the linked server item and click on Tables you should see some tables but i think you will get an error if you try clicking it. Bring up the properties of your linked server and check against my settings:

Linked server: GAMESERVER
Product name: gameserver
Provider name: Microsoft OLE DB Provider for ODBC Driver
Provider string: DRIVER={SQL Server};SERVER=<servername>;UID=;PWD=";

> Security tab - set to "Be made without using a security context"

> Server options tab - Tick all tickboxes.

Also, with the provider string do not change anything except the <servername> but, do not add UID/PWD or anything, leave it just as it is after putting your servername in ;)
 
Upvote 0
Newbie Spellweaver
Joined
Mar 1, 2007
Messages
10
Reaction score
0
That is a problem with the linked server.



That may help but if not check your linked server settings. If you open the linked server item and click on Tables you should see some tables but i think you will get an error if you try clicking it. Bring up the properties of your linked server and check against my settings:

Linked server: GAMESERVER
Product name: gameserver
Provider name: Microsoft OLE DB Provider for ODBC Driver
Provider string: DRIVER={SQL Server};SERVER=<servername>;UID=;PWD=";

> Security tab - set to "Be made without using a security context"

> Server options tab - Tick all tickboxes.

Also, with the provider string do not change anything except the <servername> but, do not add UID/PWD or anything, leave it just as it is after putting your servername in ;)

sir:
Where am I found my sever name?
Could you tell me please?
Thx bro!
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
Open a command prompt and type "hostname" or check the Computer name panel in System in the control panel.
 
Upvote 0
Back
Top