[Help] Ebenezer Error

[renatoveiga]

Hey all..I'm new here.

I'm trying setup a KO server to work a little on his database ( like adding cluster index, cover index on some procedures, and other things that will tuning a lot this database).

But when i try start Ebenezer i have this error:

"Data source name not found and no default driver specified"

Its sound like an ODBC error.

Can any1 help me with this?


server.ini

[TIMER]
YEAR=1
MONTH=1
DATE=1
HOUR=1
WEATHER=1
[VERSION]
VER=1299
[BATTLE]
WEEK=5
START_TIME=20
END_TIME=0
AUTO=0
WEEK2=6
MWEEK=5
LIMITBATTLE=200
[CASTLE]
NATION=1
[ZONE_INFO]
MY_INFO=1
SERVER_NUM=0
SERVER_COUNT=1
SERVER_00=1
SERVER_IP_00=127.0.0.1
MAX_USER=1000
[NATION]
NATION_ID=1
[FREE_ZONE]
MAX_USER=5000
[EVENT]
EVENT_NUMBER=0
[MATURE_SETTING]
PK_PERMIT=0
[MONSTER_CHALLENGE]
ACTIVATE=1
LEVEL=1
[BONUS_EVENT]
MONEY=0
EXP=0
[SG_INFO]
SERVER_INDEX=0
[MEMBER]
MEMBER=0
[GO]
THROUGH=0
[WXDZ]
WXDZ=0
[BATTLE2]
WEEK=5
START_TIME=20
END_TIME=0


gameserver.ini

[TIMER]
YEAR=2008
MONTH=3
DATE=9
HOUR=18
WEATHER=2
[LOGIN SERVER]
IP=127.0.0.1
[CASTLE]
NATION=1

[ZONE_INFO]
MY_INFO=1
SERVER_COUNT=4
SERVER_00=1
SERVER_IP_00=127.0.0.1
SERVER_01=2
SERVER_IP_01=127.0.0.1
SERVER_02=3
SERVER_IP_02=127.0.0.1
SERVER_03=4
SERVER_IP_03=127.0.0.1
SERVER_NUM=1
MAX_USER=1000
[BATTLE]
WEEK=6
START_TIME=20
END_TIME=0
AUTO=0
WEEK2=6
MWEEK=5
LIMITBATTLE=200
[AI_SERVER]
IP=127.0.0.1
[DB_SERVER]
IP=127.0.0.1
[ODBC]
GAME_DSN=kn_online
GAME_UID=knight
GAME_PWD=knight
GAME_DSN3=kn_online
GAME_UID3=knight
GAME_PWD3=knight
Account_DSN=kn_online
Account_UID=knight
Account_PWD=knight
[VERSION]
VER=1299
[SG_INFO]
GMY_INFO=1
GSERVER_COUNT=1
GSERVER_00=1
GSERVER_IP_00=127.0.0.1
SERVER_INDEX=1
[NATION]
NATION_ID=1
[FREE_ZONE]
MAX_USER=1000
[EVENT]
EVENT_NUMBER=0
[MATURE_SETTING]
PK_PERMIT=0
[MONSTER_CHALLENGE]
ACTIVATE=1
LEVEL=1
[BONUS_EVENT]
MONEY=0
EXP=0


Added System DNS
kn_online
knight_account
GameDB
AccountDB

All running over knight user.


Thanks!

 

[kenner]

It's odbc settings. try using the attached file (edit it though, my local disk is d not c).

After getting this error through though, I get an error saying "Invalid Object Name 'dbo.ITEM'---". So you may get this too, if anyone else has a solution to this please post it.

 

[renatoveiga]

Thanks Kenner.

I opened your file and add on ODBC the system DNS that i didnt have.

I got skinght login error on SQL, and i found the solution in other post here ( http://forum.ragezone.com/showthread.php?t=401778 )

I didnt get your error but i know how to fix it.

You need check permissions of knight user on SQL Server. If still getting the erro create delete the knight login on SQL server - security> logins. And add again knight user with dbo acces on kn_online database. It works for me.

 

[kenner]

I already had the permissions set, and reset them, and still no luck. I think it's a problem with the database that I restored. It's dbo user under KN_online doesn't have the login sa.


edit//
now that i've rebuilt the damn database so dbo has the login name, ebenezer's still giving me a Ducking error.

 

[renatoveiga]

try delete database and knight user on security> logins.

And start clear again.

For last test try change *.ini files to use sa login and pw. If dont work i will stay chocked.

 

[kenner]

try delete database and knight user on security> logins.

And start clear again.

For last test try change *.ini files to use sa login and pw. If dont work i will stay chocked.

I've tried all this already

 

[renatoveiga]

too much strange..

any1 have another possibility to help him?

 

[Nexux]

ok everybody here don know what the hell they are tlking about...

dude just exedit your ebenezer shearch fo sknight see what pasword is there and change it to your pasword....btw your ini is not correct:

[ODBC]
GAME_DSN=KN_online
GAME_UID=knight<---has to be sknight
GAME_PWD=knight
GAME_DSN3=KN_online
GAME_UID3=knight
GAME_PWD3=knight
Account_DSN=Knight_Account<----this is the correct!
Account_UID=knight
Account_PWD=knight


another thing you need to change user to in ebenezer wen you exedit..


Cya

 

[Nexux]

this is correct dual db ini setup:

Aujard.ini:
[ODBC]
ACCOUNT_DSN=Knight_Account
ACCOUNT_UID=*
ACCOUNT_PWD=*
LOG_DSN=KN_online
LOG_UID=*
LOG_PWD=*
GAME_DSN=KN_online
GAME_UID=*
GAME_PWD=*
GAME_DSN2=KN_online
GAME_UID2=*
GAME_PWD2=*

EBENZER:
[ODBC]
GAME_DSN=KN_online
GAME_UID=
GAME_PWD=
GAME_DSN3=KN_online
GAME_UID3=
GAME_PWD3=
Account_DSN=Knight_Account
Account_UID=
Account_PWD=

login server:
[DOWNLOAD]
URL=knightempire.info
PATH=/
[CONFIGURATION]
DEFAULT_PATH=c:\ftp\

[ODBC]
DSN=Knight_Account
UID=
PWD=
TABLE=VERSION

ODBC:
ODBC / DATABASE
AccountDB = Knight_Account
Knight_account = Knight_account
KN_online = GAMEDB
KN_Data = GAMEDB
knight = Knight_Account
GAMEDB = GAMEDB

 

[fernando]

Hi, i have an error with ebenezer
in the log file i read this:

***close prosess - socket id = 5 ***

please help