Examkin

Question

Difficulty: MediumWindows Administrative and System Management Tools

A desktop technician is deploying a legacy 32-bit database software package on a workstation running a 64-bit edition of Windows 11 Pro. The application requires a custom Data Source Name (DSN) to establish a database connection. The technician launches the standard ODBC Data Sources administrative tool from the Administrative Tools menu and configures a System DSN, but the 32-bit application fails to recognize or connect to the data source. Which of the following actions should the technician take to resolve the issue?

  1. Launch the 32-bit ODBC Data Source Administrator utility located in the SysWOW64 folder and configure the DSN there.Answer
  2. B
    Upgrade the workstation to Windows 11 Enterprise to unlock native 32-bit database driver compatibility features.
  3. C
    Open Component Services and configure a DCOM proxy interface for the 32-bit database connection.
  4. D
    Access Indexing Options in Control Panel and add the database driver path to the indexed locations list.

Answer

Launch the 32-bit ODBC Data Source Administrator utility located in the SysWOW64 folder and configure the DSN there.
On 64-bit versions of Windows, 32-bit and 64-bit applications use different registries and driver subsystems. The default ODBC shortcut in Administrative Tools points to the 64-bit tool (in System32). Creating a DSN there makes it visible only to 64-bit applications. To support a 32-bit application, the technician must execute the 32-bit ODBC Data Source Administrator tool located at C:\Windows\SysWOW64\odbcad32.exe.

Step-by-Step Solution

1
Identify the root cause of the connection failure.
Recognize that 64-bit Windows maintains separate ODBC Data Source Administrator tools for 32-bit and 64-bit drivers.
32-bit applications cannot read 64-bit DSN entries created in the default 64-bit ODBC Administrator.
2
Locate the 32-bit ODBC Data Source Administrator tool.
Navigate to C:\Windows\SysWOW64\odbcad32.exe.
The SysWOW64 directory contains 32-bit system binaries for 64-bit Windows installations.
3
Create the required System DSN using the 32-bit utility.
The 32-bit application successfully connects to the database.
32-bit applications require DSNs created within the 32-bit ODBC environment.

Key Concept

ODBC Data Sources (32-bit vs 64-bit) Architecture in Windows
Rate this question

Topics

Windows Administrative and System Management Tools

More questions from this topic