Databaseserver wont load..

01/25/2013 15:06 arnootie#1
hallo,

so i was making my SQL server etc etc and i have done everything thing right i think ;)

but wen i wanne open DatabaseServer.exe it wont load and i got this error logs at my repack folder:

CQuery-LogFile_20130125
Quote:
2013/01/25 15:02:03
query:TAX_INFO_STR 'S1', '01', 0, 0, '0', '0', 0, '0'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'TAX_INFO_STR'.
2013/01/25 15:02:03
query:uspRestoreCouple 1
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'uspRestoreCouple'.
2013/01/25 15:02:04
query:uspLoadPlayerData '01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'uspLoadPlayerData'.

error_20130125
Quote:
2013/ 1/25 15:02:03
\Users\Arno\Games\Flyff\2. Own Filles\Official V15\3.Source\Official Source\_Common\Tax.cpp, 738 TAX_INFO_STR 'S1', '01', 0, 0, '0', '0', 0, '0'

error_20130125
Quote:
2013/ 1/25 15:02:03 couldn't execute uspRestoreCouple

2013/ 1/25 15:02:04 LoadPlayerData - query: uspLoadPlayerData '01'

i made a server with sql like 3 time's and i never had this problem.. how can i fix it?


thanks
01/25/2013 15:29 Mognakor#2
Srsly, the error tells you what the problem is, all you need is some knowledge in english...

Open the SQL Server Management Studio and log into your database, then check if those procedures exist: 'TAX_INFO_STR' 'uspRestoreCouple' 'uspLoadPlayerData'

Either you create each of those manually or you delete the Database and create again, the second option should be easier.
01/25/2013 16:11 arnootie#3
Quote:
Originally Posted by Mognakor View Post
Srsly, the error tells you what the problem is, all you need is some knowledge in english...

Open the SQL Server Management Studio and log into your database, then check if those procedures exist: 'TAX_INFO_STR' 'uspRestoreCouple' 'uspLoadPlayerData'

Either you create each of those manually or you delete the Database and create again, the second option should be easier.
you think i dont try it? i have restore is 2x already, and i try the AIO database from sedrika.. i got the same error each time! thads why i post about it..

you know how i could fix it or how to create each of them manually?
01/25/2013 16:38 Mognakor#4
Did you create the ODBC's and configure your DatabaseServer.ini?
01/25/2013 17:04 arnootie#5
Yes i have it..

my ODBC:

[Only registered and activated users can see links. Click Here To Register...]


and my database

DatabaseServer.ini

Quote:
ResourceFolder "C:\Users\***\Games\Flyff\2. Own Filles\Official V15\2.Resource\Resource"
Sys 1
Account "127.0.0.1"

DSN_NAME_CHARACTER "character01"
DB_ADMIN_ID_CHARACTER "character01"

DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "log01"

DB_PWD_LOG "MyPass"
DB_PWD_CHARACTER "MyPass"
DB_PWD_BACKEND "MyPass"
DB_PWD_ITEMUPDATE "MyPass"
01/26/2013 13:59 arnootie#6
bumping? :S
01/28/2013 18:19 arnootie#7
push, i realy dont know how to fix! i re-instald and everything!