Understanding 32-bit vs. 64-bit ODBC Driver Configurations

Summary

This article explains the differences between 32-bit and 64-bit ODBC drivers and provides guidance for configuring the correct driver on your workstation.

Key Information

When configuring an ODBC driver, it’s important to use the correct 32-bit or 64-bit version for your application. Using the incorrect driver version may prevent your application from connecting to the database or cause the DSN to not appear in the expected ODBC manager.

Installation and DSN setup steps may vary by database provider, so always refer to your provider’s documentation for setup instructions.

Important Note: VDM Version 10 and later exclusively support 64-bit drivers.

Tips for Configuring ODBC Drivers

Using 32-bit Drivers on a 64-bit Workstation

To configure a 32-bit DSN on a 64-bit workstation, while System32 contains the 64-bit version., use the 32-bit Windows ODBC Administrator located at:

C:\Windows\SysWOW64\odbcad32.exe

Using 64-bit Drivers on a 64-bit Workstation

To configure a 64-bit DSN on a 64-bit workstation, use the 64-bit Windows ODBC Administrator located at:

C:\Windows\System32\odbcad32.exe

Important Notes

1. Although the folder names may seem reversed, SysWOW64 contains the 32-bit ODBC Administrator, while System32 contains the 64-bit version.

2. BridgeWorks does not provide support for installing or configuring ODBC drivers. Please contact your database provider for assistance.

Common Symptoms of Incorrect Driver Configuration

• DSN does not appear in the ODBC manager
• Connection tests fail unexpectedly
• Application cannot detect the configured driver
• Data source appears in one ODBC manager but not the other