[HELP]Making The Server Conect To Database

[sciso]

hi all guys how to make server connect to database?

on my logs is saying

[2013-08-23 02:35:30]Query(601:select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual) Error:0
Param:
Error:0:1:SQLAllocHandle:[08003][Microsoft][ODBC Driver Manager] The connection is not open


help guys!

if you guys have an DriftHook.dll with redirector to localhost it will help very much!

EDIT:My GDBC.xlt

[DBCONN]
0 SKDBTW
1 SKID
2 ihax

 

[trigunmaster]

if use original setting get log same thread

but i fix USER PASS on MSSQL to user:SKID pass:SKID and ZoneServerConfig.ini get new error but sure connect to mssql

[2013-08-24 14:01:21]Query(400:insert into SKID_STLOG_TB(LOGNAME,LOGKEY,SERVERID,CID,CNAME,CREATEDATE,N1ARG,N2ARG,N3ARG,TXTCONTENT) values(?,?,?,?,?,SYSDATE,?,?,?,?)) Error:8180
Param:serverStart 0 29 0 admin 168 1 37 server started
Error:8180:2:SQLExecute:[42000][Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

[2013-08-24 14:01:21]Query(601:select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual) Error:8180
Param:
Error:8180:2:SQLExecute:[42000][Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

[2013-08-24 14:01:21]Query(250:SELECT CID, CNAME, REGID,ITEMID,ITEMNUM,NRANDOM,NUPGRADE,INVENIDX,PRICE,STATE,ASSIST_A,ASSIST_B,BOX,CTIME,TO_CHAR(REGDATE, 'YYYY-MM-DD HH24:MI:SS') FROM SKID_AUCTION_TB WHERE SERVERID=? AND STATE=?) Error:8180
Param:29 1
Error:8180:2:SQLExecute:[42000][Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.


I need installed more than this

 

[sciso]

i tried to change pass from ihax to SKID but same error on logs!

 

[sciso]

no one can help me?

 

[WARonline]

hi all guys how to make server connect to database?

on my logs is saying

[2013-08-23 02:35:30]Query(601:select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual) Error:0
Param:
Error:0:1:SQLAllocHandle:[08003][Microsoft][ODBC Driver Manager] The connection is not open


help guys!

if you guys have an DriftHook.dll with redirector to localhost it will help very much!

EDIT:My GDBC.xlt

[DBCONN]
0 SKDBTW
1 SKID
2 ihax

Your config from server files can not connect to the databases because it's a problem in ODBC config. Check it again

 

[sciso]

i fixed this problem

 

[WARonline]

You could perhaps create a .dll file to do what you want to do.

 

[savetherobots]

You could perhaps create a .dll file to do what you want to do.

do you even have any idea what you say

like

ever