Check the Driver Architecture and Gateway Connection

These commands inspect the configuration without displaying a password. Run each command separately in Windows PowerShell:

Get-OdbcDriver -Platform '32-bit' | Where-Object Name -like '*APPX*' | Select-Object Name, Platform
Get-OdbcDsn -Name AppxODBC -DsnType System -Platform '32-bit' | Select-Object Name, DriverName, Platform, DsnType
Test-NetConnection localhost -Port 1992 -InformationLevel Quiet

The first two commands should show the 32-bit driver and System DSN. The last returns True when a TCP connection to the local gateway succeeds. On a separate desktop, replace localhost with the gateway hostname. This tests the TCP listener; the credential-prompting SQL query checks the remaining login and data path.

After changing an installed driver or DSN, close and restart clients, including PowerShell. An existing process can retain a previously loaded driver even though the DSN now points to a different file. The 5.5.3 query was verified from a fresh process.