Services wont start

[xelloz]

I got 3 services that doesnt want to start, AccountLog DB Server, Character DB server and Gamelog DB Server.
error logs: 000088 2019-11-19 00:16:56 <NUMBER OF 80 IOCP WORKTHREAD STARTED, 16 CPU DETECTED>000089 2019-11-19 00:16:56 DB_Init FAILED = DSN=AccountLog; UID=sa; PWD=123000090 2019-11-19 00:16:56 <SESSION WORKER #0 INIT DB FAILED - STOP ******>000091 2019-11-19 00:16:56 < END OF MAIN = 0 >

000088 2019-11-19 00:17:03 <NUMBER OF 80 IOCP WORKTHREAD STARTED, 16 CPU DETECTED>000089 2019-11-19 00:17:03 DB_Init FAILED = DSN=w00_Character; UID=sa; PWD=123000090 2019-11-19 00:17:03 <SESSION WORKER #0 INIT DB FAILED - STOP ******>000091 2019-11-19 00:17:03 < END OF MAIN = 0 >

000088 2019-11-19 00:17:14 <NUMBER OF 80 IOCP WORKTHREAD STARTED, 16 CPU DETECTED>000089 2019-11-19 00:17:14 DB_Init FAILED = DSN=w00_GameLog; UID=sa; PWD=123000090 2019-11-19 00:17:14 <SESSION WORKER #0 INIT DB FAILED - STOP ******>000091 2019-11-19 00:17:14 < END OF MAIN = 0 >
Any help would be appreicated.

[MentaL]

[Delius]

Check your config + ODBC names.

[KuminDesu]

Fck ODBC just use this:
ODBC_INFO "Account" , 0 , 0 , "DRIVER={SQL Server};SERVER=NAME\SQLEXPRESS; UID=sa;PWD=PASSWORD", "USE Account; SET LOCK_TIMEOUT 5000"

[celialima]

try it

; ODBC-----------------------------------------------------------------------------------------------------------------------------------------

; ODBC-----------------------------------------------------------------------------------------------------------------------------------------ODBC_INFO "Account", 0, 0, "DSN=Account; UID=sa; PWD=YOURPASSWORD", "USE Account; SET LOCK_TIMEOUT 5000" ; world
ODBC_INFO "AccountLog", 1, 0, "DSN=AccountLog; UID=sa; PWD=YOURPASSWORD", "USE AccountLog; SET LOCK_TIMEOUT 5000" ; world
ODBC_INFO "Statistics", 2, 0, "DSN=Statistics; UID=sa; PWD=YOURPASSWORD", "USE StatisticsData; SET LOCK_TIMEOUT 5000" ; acccount db
ODBC_INFO "OPTool", 3, 0, "DSN=OPTool; UID=sa; PWD=YOURPASSWORD", "USE OperatorTool; SET LOCK_TIMEOUT 5000" ; account db


; for first world
ODBC_INFO "w00_Character", 10, 0, "DSN=w00_Character; UID=sa; PWD=YOURPASSWORD", "USE w00_Character; SET LOCK_TIMEOUT 5000" ; world
ODBC_INFO "w00_GameLog", 11, 0, "DSN=w00_GameLog; UID=sa; PWD=YOURPASSWORD", "USE w00_GameLog; SET LOCK_TIMEOUT 5000" ; world

[xelloz]

I got it to work however i got another problem with all the zones crashing.
5ZoneServer2.exe caused an: < EXCEPTION_ACCESS_VIOLATION >In module: 5ZoneServer2.exe at: < 0023:005F83D8 >--------------------------------------------------------------------------0023:005F83D8, 5ZoneServer2.exe, 0023:005D7BD5, 5ZoneServer2.exe, 0023:005A9E99, 5ZoneServer2.exe, 0023:75D2343D, kernel32.dll, BaseThreadInitThunk()+0018 byte(s)0023:77C09812, ntdll.dll, RtlInitializeExceptionChain()+0099 byte(s)0023:77C097E5, ntdll.dll, RtlInitializeExceptionChain()+0054 byte(s)
Unsure if anyone know how to fix this

[xelloz]

All issues fixed, close the post