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! Linked Server Settings ERRORR HELP PLAESEEE

Newbie Spellweaver
Joined
Sep 3, 2008
Messages
7
Reaction score
0
Have Some problems :furious:with Linked Server !!!
:gun_rifleI enter in Cabal -> Login with my id and PAss->Select Test Server->Connect Chanel 1(Trade)->Click Create Character-> Enter The Name ->Set my face....->Click Create and it SAY:Cannot proceed with the command due to unknow DB errors.Please try again I read many Theard ,topicks, i have already usw search but i can't Correct My Problem :protest:Who Can Help MEE??? PLEASEEE:busted:
Can You Give My->Your FullDataBase (for SQL 2000 )PLease!!:flag_schw And the Correct details for Setting The Linked Server :helpsmili PLAESEEE PS: I use GP Client !! Who HAVE THAT:bye2::bye2: POWER FOR HELP ME ? :cry_1: Plaese Give ME your details not a link or another address :drinks_no
________________________________________________________
Be Cool-> Play Your Life -> PLAY CABAL
 
Newbie Spellweaver
Joined
Jun 13, 2008
Messages
33
Reaction score
0
hiya


follow chummpys guide for correct way to set link server.

and try reinstalling account db
 
Upvote 0
Experienced Elementalist
Joined
Jan 29, 2005
Messages
210
Reaction score
3
follow my picture...
about that (Cannot proceed with the command due to unknow DB errors)
is a table problem... missing data here... check you server ID...
cabal_newCharData_table
cabal_newEtcData_table
cabal_newFlagData_table
 

Attachments

You must be registered for see attachments list
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
Please post in the correct section. If you want my dbs and correct settings they are on my repack+guides topic where they have always been.
 
Upvote 0
Newbie Spellweaver
Joined
Sep 3, 2008
Messages
7
Reaction score
0
:gun_rifleOmg men...i restore all my database with your "chump_db_9.8.2008" and it give me same errror :furious::gun_rifle I take some screenshoots SEE PLEASEEE and This is correct-> DRIVER={SQL Server};SERVER=localhost;UID=;PWD=; :scratch:
Pleasee See MY PICTURES AND HELP ME !!!! :drinks_no
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
Code:
DRIVER={SQL Server};SERVER=[COLOR="Red"]localhost[/COLOR];UID=;PWD=;

Try changing that to the windows ip address. Everything else looks ok.
 
Upvote 0
Newbie Spellweaver
Joined
Nov 19, 2004
Messages
57
Reaction score
4
hmm...same problem, I'm using your repack and follow your guide too, and the database is from chump_db_9.8.2008.rar. And I'm using the Chinese client.
I'm using the MSSQL2k5, and in that pdf guide, I noticed that it need to create a new account which is called "cabal", is that necessary? Because I never see any files using that account in linux side.
The log in the DBAgent_24.log:
Code:
[Wed Sep 17 2008 12:27:38.543184 3064908688]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 8)
[Wed Sep 17 2008 12:27:38.543255 3064908688]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]The incoming tabular data stream (TDS) protocol stream is incorrect. The stream ended unexpectedly.
[Wed Sep 17 2008 12:27:38.543276 3064908688]: [##ERROR##] DB ERROR(CODE)     : 4002
[Wed Sep 17 2008 12:27:38.543293 3064908688]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Sep 17 2008 12:27:38.543311 3064908688]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Sep 17 2008 12:27:38.543328 3064908688]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?         , ?         , ?         )}
I will keep trying to find out the solution...
 
Upvote 0
Newbie Spellweaver
Joined
Sep 3, 2008
Messages
7
Reaction score
0
:drinks_noThanks chumpywumpy:drinks_no now i try to reintall the MSDSQL 2000 and i will try to set that with my windows IP :flag_schw:flag_schw Cratz chumpywumpy you are the best :drinks_no:drinks_no
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
I noticed that it need to create a new account which is called "cabal", is that necessary?

You can just use your "sa" account and password or you can create your own. I used an example account of "cabal" but i would not recommend using exactly that as if anyone tried hacking your database what would be the first account name they would try?

Code:
[##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]The incoming tabular data stream (TDS) protocol stream is incorrect. The stream ended unexpectedly.

Now that is an odd error. Everythng i can find indicates a very strage sql2005 issue and i can't find anything definite on what causes it. Do you use centos 5 and does anything else show up in your logs anywhere?
 
Upvote 0
Newbie Spellweaver
Joined
Sep 3, 2008
Messages
7
Reaction score
0
Heloo:flag_schw....i'm back but ....i have been rainstall the SQL 2000+ All DB but it give me same error :vertag:: Error 7399 :furious: i can't repair that error :scratch: What i need to do now :poster_do ? (My centos work very good only my DB is affected :Smilie: --My Centos: centos-5.1-i386-server -- only have problems with SQL 2000 :(( WHO CAN HELP MEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE ????
 
Upvote 0
Newbie Spellweaver
Joined
Sep 3, 2008
Messages
7
Reaction score
0
Please POST HERE FULL DETAILS TO CREATE A SERVER :drinks_no
Thank's all who help me :drinks_no --------------------------
Help a SAd Boy :cry_1::cry_1::cry_1::cry_1::cry_1: Who know to create a GOOD SERVER without ERROR 7399 POST HERE PLEASE :bounce8::bounce8:
 
Upvote 0
Back
Top