ODBC Troubles

[Overwerk]

Hi, so ive been setting up my new dedi and came across an error when starting the AccountLog, CharacterDB, GameLog, and OdinRestServer services. The error is this:

000028 2013-05-13 19:51:50 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
000029 2013-05-13 19:51:50 DB_Init FAILED = DSN=AccountLog;    UID=WIN-BI5T8P552N\Administrator; PWD=sa
000030 2013-05-13 19:51:50 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2013-05-13 19:51:50 < END OF MAIN = 0 >

It is like that for all of them, just a change in the DSN name.

I have it all configured correctly (from what I know) and all the ODBC's are set up correctly.

Here is the ServerInfo that I am using.

ODBC_INFO "Account",     0,    0, "DSN=Account;    UID=WIN-BI5T8P552N\Administrator; PWD=sa", "USE Account; SET LOCK_TIMEOUT 5000"
ODBC_INFO "AccountLog",  1,    0, "DSN=AccountLog;    UID=WIN-BI5T8P552N\Administrator; PWD=sa", "USE AccountLog; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Statistics",  2,    0, "DSN=Statistics;    UID=WIN-BI5T8P552N\Administrator; PWD=sa", "USE StatisticsData; SET LOCK_TIMEOUT 5000"
ODBC_INFO "OPTool",      3,    0, "DSN=OPTool;    UID=WIN-BI5T8P552N\Administrator; PWD=sa", "USE OperatorTool; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Character",   10,   0, "DSN=Character;    UID=WIN-BI5T8P552N\Administrator; PWD=sa", "USE World00_Character; SET LOCK_TIMEOUT 5000"
ODBC_INFO "GameLog",     11,   0, "DSN=GameLog;    UID=WIN-BI5T8P552N\Administrator; PWD=sa", "USE World00_GameLog; SET LOCK_TIMEOUT 5000"
#END

To me, I dont see the issue, but it is just not working.

When I start the services it gives this message:

The _AccountLog DB Server service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

This is also the same for all 4 services.


Could someone PLEASE help out with this problem and tell me what I am doing wrong and/or how to fix it. I have gone through many guides and have followed them exactly.

All help is VERY appreciated.

Thanks, Overwerk

[MentaL]

[Delius]

Make sure in both db and dsn it is spelt:
-AccountLog
-StatisticsData
-W00_Character
-W00_GameLog
Other possibilities may be that you have the wrong password.

If you need a spoon feed, I may be able to resolve the issue via skype/teamviewer.
Skype: sighofrelief1