A field technician is configuring a specialized 32-bit accounting application on a 64-bit Windows 11 Pro workstation. The installation wizard finishes without errors, and the technician successfully installs the required 32-bit database drivers. However, when attempting to set up a System Data Source Name (DSN) for the application using the standard Data Sources (ODBC) applet found in Windows Administrative Tools, the required 32-bit driver does not appear in the driver selection list. Which of the following is the most appropriate action to resolve this issue?
- Launch the 32-bit ODBC Data Source Administrator utility located at C:\Windows\SysWOW64\odbcad32.exe to configure the System DSN.Answer
- BOpen Credential Manager in Control Panel and add elevated administrative credentials for the database driver DLL.
- CRe-run the driver installation package with the /sys32 command-line switch to force installation into the System32 directory.
- DUpgrade the operating system to Windows 11 Enterprise to enable legacy 32-bit driver management in the default Control Panel applets.
Answer
Launch the 32-bit ODBC Data Source Administrator utility located at C:\Windows\SysWOW64\odbcad32.exe to configure the System DSN.
On 64-bit Windows operating systems, 32-bit applications and database drivers operate within the Windows-on-Windows 64-bit (WOW64) subsystem. The default 'Data Sources (ODBC)' tool in Windows Administrative Tools launches the 64-bit version of `odbcad32.exe` located in `C:\Windows\System32`, which can only manage 64-bit drivers. To configure a System DSN for a 32-bit driver, technicians must explicitly launch the 32-bit ODBC Administrator located in `C:\Windows\SysWOW64\odbcad32.exe`.
Step-by-Step Solution
Key Concept
32-bit vs 64-bit Application Compatibility and Architecture Management in Windows (SysWOW64 vs System32 ODBC Administrators)