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 ...
Re: EventDB Error - ODBC Driver Manager mismatch
run as admin 1st of all the edataserver
and second edit odbc.req (local) to ur-pc name.
Re: EventDB Error - ODBC Driver Manager mismatch
1) I did run as Administrator - Nothing changes
2) I dont really understand what you mean how do i edit ODBC.req ?
Re: EventDB Error - ODBC Driver Manager mismatch
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...
Re: EventDB Error - ODBC Driver Manager mismatch
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
Re: EventDB Error - ODBC Driver Manager mismatch
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
Re: EventDB Error - ODBC Driver Manager mismatch
Re: EventDB Error - ODBC Driver Manager mismatch
Re: EventDB Error - ODBC Driver Manager mismatch
delete database and restore it as MU_2003_EVENT_DATA
if still not working then restore as
Event
Re: EventDB Error - ODBC Driver Manager mismatch
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
Re: EventDB Error - ODBC Driver Manager mismatch
glad i helped ;) gl with ur server.