excel - Odbcad32.exe file corrupted -
i cannot set excel odbc drivers data sources in control panel. excel drivers not shown in list.
i have tried odbcad32.exe file in windows/syswow64 folder, set file, couldn't set file in windows\system32
. , jdbc program couldn't connect driver.
the odbcad32.exe file in syswow64 working, replaced same file in system32 file. way able create driver. on running jdbc program, i'm getting error
the specified dsn contains architecture mismatch between driver , application
i'm using windows7 64 bit. office 2007
don't mix 32 , 64 bit versions of odbcad32.exe
. think bad both 32 , 64 bit versions have same name, how ms build it. in system32
there 64 bit version of odbcad32.exe
. in windows/syswow64
there 32 bit version of odbcad32.exe
.
configuration of odbc stored in registry. native, 64 bit applications including odbcad32.exe
use:
hkey_local_machine\software\odbc\odbc.ini
if use such registry location 32 bit apps windows redirects to:
hkey_local_machine\software\wow6432node\odbc\odbc.ini
you find more registry redirection at: http://support.microsoft.com/kb/305097
if of odbc administrative programs corrupted not exchange versions other directories, not mix 32 , 64 bit versions. solution see clean install them cd or copy them other machine.
Comments
Post a Comment