APPX Software Library

Chapter 2: Install and Check APPX ODBC

Install the 5.5.1 Gateway and ASQL

  1. Confirm that APPX 5.5.1 is installed and licensed and that an authorized user can open its DMO application. Check the engine's actual version if an existing folder has been upgraded. This example uses a clean 32-bit installation at C:\appx\Appx.551 and its login manager on localhost:31052. The usual APPX port is 8060; use the configured port at your site.
  2. Download the official 5.5.1 gateway and 5.5.1 driver and ASQL package. The APPX download archive also provides the matching server installation.
  3. Verify the downloads from Command Prompt, one command at a time:
certutil.exe -hashfile "AppxODBCserver_windows.exe" SHA256
certutil.exe -hashfile "AppxODBCdriver+ASQL_windows.exe" SHA256
DownloadSHA-256
AppxODBCserver_windows.exeb5f6628037ec2cf9d19f7ad9fb251d89394665631033b99a120ea7b52ddcb2be
AppxODBCdriver+ASQL_windows.exe5645004fbdf921fe581940709b8fc0f86b9ea26221b3f564b4f340d1bc3c49de
  1. Right-click the gateway installer and select Run as administrator. Select Next and keep C:\Program Files (x86)\AppxODBCserver and the default Start menu folder.
The matching gateway installer identifies APPX ODBC Server 5.5.1.
Figure 1. The matching gateway installer identifies APPX ODBC Server 5.5.1.
  1. Enter the APPX server's hostname and login-manager port. The example uses localhost and 31052. These fields identify the APPX backend, not the ODBC gateway port. Complete the wizard.
Point the gateway to the intended APPX login manager.
Figure 2. Point the gateway to the intended APPX login manager.
  1. On the ASQL administration computer, run the matching driver and ASQL installer as administrator. Keep C:\Program Files (x86)\AppxODBCDriver and the default Start menu folder.
Install the driver and ASQL supplied in the 5.5.1 package.
Figure 3. Install the driver and ASQL supplied in the 5.5.1 package.
  1. Keep Create System DSN selected. Enter the gateway hostname, localhost when it is on this computer. Keep Data Source Name AppxODBC and Database appx. Complete setup, then check the gateway Windows service and DSN.
Keep the default AppxODBC data source and appx dictionary.
Figure 4. Keep the default AppxODBC data source and appx dictionary.

The installer creates the default dictionary; an additional mdcreate command is unnecessary. Preserve an existing gateway dictionary and configuration before replacing an installation. Use the ASQL import recipe after the connection checks.