Agian char screen DC

01/23/2013 17:34 Tomiscool#1
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
01/23/2013 18:56 TeddyBear94#2
Quote:
Originally Posted by Tomiscool View Post
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
LMFAO :facepalm: 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.
01/23/2013 19:00 Tomiscool#3
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)
01/23/2013 19:03 Dreameh#4
Quote:
Originally Posted by Tomiscool View Post
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". :facepalm:
01/23/2013 19:08 TeddyBear94#5
fix ur linked servers use the search button to find the fix.
01/23/2013 19:25 Tomiscool#6
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
01/23/2013 19:39 TeddyBear94#7
i hope u deleted first all linked servers and readded them then with the script + u run the sql new installation script aswell.
01/23/2013 19:48 Tomiscool#8
okay i messed this all up im just gona redo the whole thing which DB files should i use
01/23/2013 20:57 Tomiscool#9
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
01/24/2013 13:03 nephren#10
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.