Can I can connect a 64 bit application to a 32 bit ODBC driver?
Similarly, you may ask, how do I use 32 bit ODBC on 64 bit?
If you build and then run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source by using the ODBC Administrator tool in %windir%SysWOW64odbcad32.exe. To indicate the type of DSN, you can add "_32" to the 32-bit user DSNs and "_64" to the 64-bit user DSNs.
Also question is, how do I install 64 bit ODBC driver?
Create an ODBC data source on 64-bit computers
- In Windows Explorer, navigate to C:WindowssysWOW64 .
- Double-click odbcad32.exe .
- Click the System DSN tab.
- Click Add.
- Scroll down through the list and select SQL Server, and then click Finish.
- In Name and Description, type the name and a description for the ODBC data source you are creating.
For a system running a 64-bit version of Microsoft Windows, perform the following procedure to access the ODBC administration application: From the search bar field in Windows, type C:WindowsSysWOW64odbcad32.exe and press 'Enter'. The ODBC Data Source Administrator window opens. Select the System DSN tab.