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

Popular posts from this blog

c# - How to set Z index when using WPF DrawingContext? -

razor - Is this a bug in WebMatrix PageData? -

visual c++ - Using relative values in array sorting ( asm ) -