EventDB Error - ODBC Driver Manager mismatch

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 : http://img703.imageshack.us/img703/2997/odbcerror.png

Uploaded with ImageShack.us

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

Screen : http://img209.imageshack.us/img209/8213/odbcerror2.png

Uploaded with ImageShack.us

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

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

1) I did run as Administrator - Nothing changes

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

Quote:

---

Originally Posted by epocal

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.

Code:

---

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...

---

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 http://img195.imageshack.us/img195/6687/error32.png

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

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

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

I've did what you told me so :

Screen 1

http://img33.imageshack.us/img33/4941/error1flv.png

Uploaded with ImageShack.us

Screen 2

http://img163.imageshack.us/img163/443/error2m.png

Uploaded with ImageShack.us

Screen 3

http://img10.imageshack.us/img10/6531/error3t.png

Uploaded with ImageShack.us

Screen 4

http://img651.imageshack.us/img651/3697/error4a.png

Uploaded with ImageShack.us

Screen 5

http://img687.imageshack.us/img687/6781/error5.png

Uploaded with ImageShack.us

Any other solutions ? I look farward ...

Any solutions ?

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

Quote:

---

Originally Posted by karLi

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 :

http://img822.imageshack.us/img822/7817/rezxolvat.png

Uploaded with ImageShack.us

glad i helped ;) gl with ur server.