Agian char screen DC

[Tomiscool]

okay i know there is tons of posts about this on here ive read everyone and have not found a solid answer . i do not know how to show logs but if you skype me i can screen share or you can tell me how to do it skype : Dudes_son please just dont say use the stupid search bar ive read all the posts

[TeddyBear94]

Originally Posted by Tomiscool

okay i know there is tons of posts about this on here ive read everyone and have not found a solid answer . i do not know how to show logs but if you skype me i can screen share or you can tell me how to do it skype : Dudes_son please just dont say use the stupid search bar ive read all the posts

***** no joke if u would have read "all posts" then u would have find ur answer since its that easy.
open c:/shaiyaserver/psm_client/bin/loggs and there u will find txt files open these txt files and exactly what u see in them are ur loggs ...
next time speant a bit more time on the search engine not just 1 minute.

just a side note without valid loggs we actually cant rly tell u what the problem is even if i believe that ur client is the problem.

[Tomiscool]

2013-01-21 23:00:09 PS_DBAGENT__system log start (DBAgent01)

2013-01-21 23:00:48 connect game, Name=



2013-01-21 23:00:48 connect game, Name=



2013-01-21 23:04:17 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-21 23:04:17 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2013-01-21 23:17:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-21 23:17:04 ::LoadCharacter 2 UGotLvled qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,1,'AdminTom')}

2013-01-21 23:17:04 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2013-01-21 23:19:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-21 23:19:11 ::LoadCharacter 2 UGotLvled qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,1,'AdminTom')}

2013-01-21 23:19:11 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2013-01-21 23:24:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-21 23:24:33 ::LoadCharacter 2 UGotLvled qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,1,'AdminTom')}

2013-01-21 23:24:33 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2013-01-21 23:28:52 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-21 23:28:52 ::LoadCharacter 3 Test qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,2,'tom')}

2013-01-21 23:28:52 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2013-01-21 23:33:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-21 23:33:54 ::LoadCharacter 3 Test qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,2,'tom')}

2013-01-21 23:33:54 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2013-01-22 06:09:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-22 06:09:20 ::LoadCharacter 3 Test qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,2,'tom')}

2013-01-22 06:09:20 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2013-01-22 06:11:28 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-22 06:11:28 ::LoadCharacter 4 566556 qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,2,'tom')}

2013-01-22 06:11:28 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2013-01-22 06:24:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-22 06:24:42 ::LoadCharacter 4 566556 qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,2,'tom')}

2013-01-22 06:24:42 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2013-01-22 11:44:13 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-22 11:44:13 ::LoadCharacter 4 566556 qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,2,'tom')}

2013-01-22 11:44:13 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2013-01-22 11:47:32 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'game' in sysservers. Execute sp_addlinkedserver to add the server to sysservers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2013-01-22 11:47:32 ::LoadCharacter 5 156645651 qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,2,'tom')}

2013-01-22 11:47:32 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

[Dreameh]

Originally Posted by Tomiscool

Please just dont say use the stupid search bar ive read all the posts

Obviously not, if you did then you wouldn't be here asking it. There are answers out there if you read. Even the post's that have [Help] beside it contain answers, and as Teddy said "Your logs".

[TeddyBear94]

fix ur linked servers use the search button to find the fix.

[Tomiscool]

okay aperently im stupid because i cannot find how to fix my linked servers could one of you please post a link

okay i ran the queey to fix my linked servers still same issue of DC at gamestart

[TeddyBear94]

i hope u deleted first all linked servers and readded them then with the script + u run the sql new installation script aswell.

[Tomiscool]

okay i messed this all up im just gona redo the whole thing which DB files should i use

[Tomiscool]

okay i fixed that now it feezes then after a few seconds DC when i hit start game my logs now 13-01-22 14:02:03 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]VIA Provider: The specified module could not be found.

, SQL STATE: 42000, NATIVE ERROR: 126 (0x7E)

2013-01-22 14:02:03 ::LoadCharacter 1 Test qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,1,'tom')}

2013-01-22 14:02:03 ErrorMsg=[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "SQLNCLI" for linked server "game" returned message "Login timeout expired"., SQL STATE: 01000, NATIVE ERROR: 7412 (0x1CF4)
what does this mean

[nephren]

So what does your log say ?

[Microsoft][ODBC SQL Server Driver][SQL Server]VIA Provider: The specified module could not be found. <
VIA Provider does not exist

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "SQLNCLI" for linked server "game" returned message "Login timeout expired".

Check your Linked Servers as Teddy already mentioned.