Can i use a 32 Bit ODBC Driver for the 64 Bit app

32bit-64bitodbcwinapi

I have a Win32 application that makes ODBC-Connections. We connect using SQLDriverConnect()
which displays a dialog to select the data source. In the x64-Version the Dialog shows and offers 2 different 32 Bit MS ACCESS Drivers. When i select one of these, in the 32 Bit version i would see a open file dialog to select a .mdb file. In the 64 Bit version the call to SQLDriverConnect() at this point returns with -1.

SQLError() returns: "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

Is it in general possible to use a 32 Bit ODBC Driver from a 64-Bit executable? Why are these driver shown? As far as i can find there is no 64 Bit MS Access OBDC driver so far. What can i do?

Best Answer

You absolutely cannot mix 32bit application and 64bit driver (or vice-versa).

Basically, an ODBC driver is, typically, a dll (windows) or a shared object (linux...) which is loaded by its parent application.

All executables, dlls, etc that share the same process space must be the same bit'ness...

Related Solutions

.net – How to use a 32-bit ODBC driver on 64-bit Server 2008 when the installer doesn’t create a standard DSN

It turns out that you can create 32-bit ODBC connections using C:\Windows\SysWOW64\odbcad32.exe. My solution was to create the 32-bit ODBC connection as a System DSN. This still didn't allow me to connect to it since .NET couldn't look it up. After significant and fruitless searching to find how to get the OdbcConnection class to look for the DSN in the right place, I stumbled upon a web site that suggested modifying the registry to solve a different problem.

I ended up creating the ODBC connection directly under HKLM\Software\ODBC. I looked in the SysWOW6432 key to find the parameters that were set up using the 32-bit version of the ODBC administration tool and recreated this in the standard location. I didn't add an entry for the driver, however, as that was not installed by the standard installer for the app either.

After creating the entry (by hand), I fired up my windows service and everything was happy.

ODBC driver (AcuODBC, MS Access Driver)

You probably don't need to download new drivers, you just need to use the 32 bit version of the ODBC administrator found in:

%windir%\syswow64\odbcad32.exe

The ODBC administrator in the control panel is the 64 bit version which won't show any 32 bit drivers. If your application is 32 bit then you need a 32 bit dsn created in the 32 bit ODBC administrator.

Best Answer

Related Solutions

.net – How to use a 32-bit ODBC driver on 64-bit Server 2008 when the installer doesn’t create a standard DSN

ODBC driver (AcuODBC, MS Access Driver)

Related Topic