APPX Software Library

Chapter 2: Install and Check APPX ODBC

Install the 5.5.3 Gateway and ASQL

  1. Confirm that you can log into APPX 5.5.3 and open the DMO application. Record the APPX server name and login-manager port. This example uses localhost:31054 and the Windows login manager's Pipe interface.
  2. Download the 5.5.3 gateway installer and the 5.5.3 driver and ASQL installer.
  3. Open Command Prompt in the download folder and verify each download with certutil.exe -hashfile "filename.exe" SHA256.
DownloadSHA-256
AppxODBCserver_windows.exefc655f512746940e3eb02cd234ad4ee3549bb409e6339db80000d15f6aa4d1d9
AppxODBCdriver+ASQL_windows.exe7b6d67289a9b5e9ca0d5246311b62cec0e03f22e8fcf6daf3db5a2bbdb4e60d5
  1. Right-click the gateway installer and choose Run as administrator. Select Next on the 5.5.3 welcome page and keep the default installation directory, C:\Program Files (x86)\AppxODBCserver.
The gateway installer identifies APPX ODBC Server 5.5.3.
Figure 1. The gateway installer identifies APPX ODBC Server 5.5.3.
  1. Enter the APPX server's hostname and login-manager port. For this example, enter localhost and 31054, then complete the wizard.
The gateway's backend is the APPX login manager, localhost:31054 in this example.
Figure 2. The gateway's backend is the APPX login manager, localhost:31054 in this example.
  1. On the designated ASQL administration computer, install the 5.5.3 driver and ASQL package as administrator, keeping C:\Program Files (x86)\AppxODBCDriver. Keep this version of ASQL Dictionary Importer for Import COUNTRY with ASQL. Follow Install the 6.2.1 Client Driver to extract the 6.2.1 client driver and update the default AppxODBC DSN.
The ASQL package comes from the matching 5.5.3 release.
Figure 3. The ASQL package comes from the matching 5.5.3 release.
  1. Install the Microsoft x86 runtime, then start and check the gateway. Apply additional package repairs only if that check fails. If optional DSN creation displays the following error, follow Resolve System DSN Error 126 before reopening the setup dialog:
Error Executing Action

CONFIGSYSDSN: Unable to create a data source for the
'AppxODBC Driver' driver:
    The setup routines for the AppxODBC Driver ODBC
 driver could not be loaded due to system error code 126: The
 specified module could not be found.
 (C:\PROGRA~2\APPXOD~2\\dhsetup.dll). with error code
 -2147467259
Full error 126 message from the 5.5.3 driver installer.
Figure 4. Full error 126 message from the 5.5.3 driver installer.

The client-driver recipe extracts selected DLLs from the 6.2.1 package without running its installer. It keeps the 5.5.3 gateway, matching ASQL and existing appx dictionary. Test any changes on a copy of an existing production installation first.