Introduction
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:
A common point of confusion for developers and database administrators migrating to 64-bit versions of Windows is the handling of legacy database connections. You might have a 32-bit application that requires a specific 32-bit ODBC driver, but your operating system is the 64-bit version of Windows 7.
| 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 |
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.
Introduction
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:
A common point of confusion for developers and database administrators migrating to 64-bit versions of Windows is the handling of legacy database connections. You might have a 32-bit application that requires a specific 32-bit ODBC driver, but your operating system is the 64-bit version of Windows 7.
| 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 |
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.
YOU CAN HAVE WITH PHOTOS!
