odbc administrator system error code 193

Question

I am trying to create data soucre using microsoft odbc administrator.  I am running Windows 7 business 64 bit version.  I have oracle 11g 64 bit instant client and the 64 bit ODBC drivers installed.   The driver shows up when I click add but then I get a messages saying "The setup routines for the Oracle in instantclient11_1 ODBC driver could not be loaded due to system error code 193.

Any help would be greatly appreciated.

Thanks

Answer 1

This error code means this:

ERROR_BAD_EXE_FORMAT 193 (0xC1)

%1 is not a valid Win32 application.

If you are talking about ODBCAD32.exe, then it looks like the installation of the driver mis-registered a 32 bit driver ad 64 bit or vise-versa.  It is trying to load either a 32 bit driver from the 64 bit version (C:\windows\system32\odbcad32.exe) or trying to load a 64 bit driver from the 32 bit version (C:\windows\syswow64\odbcad32.exe).  As the driver listing is determined by registry keys that are set on installation of the driver, it is likely that the driver installer has a fault which is causing it to be mis-registered with ODBC.

I would take this up with Oracle from here, I suppose.

Hope that helps,

John

---

This post is provided 'as is' and confers no express or implied warranties or rights.

Answer 2

Hello, I had this problem trying to configure postgresql via odbc, which 
generated the same error ... 
It worked perfectly with your tips. 
Sincerely.

Answer 3

Hi Junior,

    So what change did you do in the installer for avoiding the error ?

 

-Manoj

Answer 4

Hey john i had a same problem, so do we need to change in oracle ..... so please can u tell step by step procedure to solve this error

Answer 5

I had the same problem. We changed the Target Path for the execution of the ODBC from "%SystemRoot%\system32\odbcad32.exe" to "%SystemRoot%\sysWOW64dbcad32.exe". And it worked Thanks for the help!

Answer 6

Create a new short cut on desktop, type the location of the item "%systemdrive%\Windows\SysWoW64\odbcad32.exe", click Next, then enter "32 bits ODBC Connection", click Finish.

Create a another short cut on desktop, type the location of the item "%WINDIR%\System32\odbcad32.exe", click Next, then enter "64 bits ODBC Connection", click Finish.

Use these short cut for your ODBC Setup.  I hope it helps.