32-bit Odbc Driver On 64-bit — Windows 7

Contrary to popular belief, . However, the critical detail lies in which administrative tool you use to configure them . The Core Concept: Two ODBC Administrators Windows 7 (64-bit) has two separate ODBC Data Source Administrator (ODBCAD32.exe) tools:

Introduction

| Aspect | 64-bit Administrator | 32-bit Administrator | | :--- | :--- | :--- | | | C:\Windows\System32\odbcad32.exe | C:\Windows\SysWOW64\odbcad32.exe | | Manages | 64-bit ODBC drivers only | 32-bit ODBC drivers only | | Visibility | Default shortcut in Admin tools | Hidden; must be run manually | 32-bit odbc driver on 64-bit windows 7

Running 32-bit ODBC drivers on 64-bit Windows 7 is not only possible but fully supported by Microsoft. The only real obstacle is remembering that Windows hides the correct configuration tool in the SysWOW64 folder. By using the right administrator for the job, you can seamlessly bridge the gap between legacy 32-bit applications and modern database systems without changing a single line of code. Contrary to popular belief,