EventDB Error - ODBC Driver Manager mismatch

[epocal]

Hello,

I used Search option and didn't found any viable solution for my problem so :

My OS : Windows 7 64 BIT Home Edition
My Server : Season II By MTT ( MMT_Production_2.00.05 )
SQL : 2000
ODBC ( I use ) : Normal ODBC from ( DB Backs ) + I downloded and execute some WIN 7 64 BIT ODBC form a forum. ( I don't know if it works but i tried )

Enteprise Manager database name : MuOnline_Event

MyComputer/D/MuServer/Bin/AllServer/ServerConfigs ( EventDNS = MuOnline_Event )

All other DB Connect Succesful. I posted all the info i think you need for helping me.

The BIG probelm : [EventDB] Error on connection

SQLSTATE:IM014, Diagnosis: [Microsoft][ODBC Driver Manager] The specific DNS contains an architecture mismatch between the Driver and Application

Screen :

Uploaded with ImageShack.us

PS : If i try other server i get the same :

Screen :

Uploaded with ImageShack.us

Thank You, and hope to get this resolved with your help soon ...

[MentaL]

[KarLi]

run as admin 1st of all the edataserver
and second edit odbc.req (local) to ur-pc name.

[epocal]

1) I did run as Administrator - Nothing changes

2) I dont really understand what you mean how do i edit ODBC.req ?

[Acnathon]

2) I dont really understand what you mean how do i edit ODBC.req ?

An ODBC.reg file comes with the repack... (right click -> edit) thats what karLi meant.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Event]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalServer]
"Server"="(local)"
"Trusted_connection"="Yes"
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"LastUser"="Administrator"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LOGIN]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MU2003_EVENT_DB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MU2003_EVENT_DATA"
"LastUser"="Administrator"

etc, etc, etc...

[epocal]

Ok, I did all this and THE ERROR is still there ... nothing changed :

1. Runned all as Administrator

2. Changed the ODBC file + Screen Here

Uploaded with ImageShack.us

3. I went to Start > Control Panel > Administrative Tools > Data Sources > System DSN , i Removed all and again used the ODBC in DB BACKS in MuServer ... but still nothing happens, i still have that error.

Any other sugestions ? Thank You

[Alexell]

look on ODBC.reg and create all DB with exactly name like there: example: MU2003_EVENT_DATA not MuOnline_Event restore all DB, apply ODBC.reg chek server config files to be the same with DB and start srv

[epocal]

This is starting to get me angry ! ERROR - NOT SOLVED

I've did what you told me so :

Screen 1



Uploaded with ImageShack.us

Screen 2



Uploaded with ImageShack.us

Screen 3



Uploaded with ImageShack.us

Screen 4



Uploaded with ImageShack.us

Screen 5



Uploaded with ImageShack.us

Any other solutions ? I look farward ...

[epocal]

Any solutions ?

[KarLi]

delete database and restore it as MU_2003_EVENT_DATA
if still not working then restore as
Event

[epocal]

delete database and restore it as MU_2003_EVENT_DATA
if still not working then restore as
Event

Thank you. It worked
You have my like :)

For other who get the same error, Solved by rename event.ini with :

mu2003_dbname = Event
mu2003_dsn = Event

And in Enteprise Manager make new database with name Event. > Restored > Used ODBC and all fine now as you can see :



Uploaded with ImageShack.us

[KarLi]

glad i helped ;) gl with ur server.