APPX Software Library

Chapter 2: Install and Check APPX ODBC

Install the 5.5.2 Gateway and ASQL

  1. Confirm that APPX 5.5.2 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 official 32-bit 5.5.2 installation at C:\appx\Appx.552 and its login manager on localhost:31053. The usual APPX port is 8060; use the configured port at your site.
  2. Download the official 5.5.2 gateway and 5.5.2 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.exe12f7a0d0f06cd0a457356458d4282a45f46cecd8aeb0202e34b5fe55a1e91a58
AppxODBCdriver+ASQL_windows.exec378ff56bb39b6745adbae2efef15038b5f0fa9e5cb309d4691d1c71cb767947
  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 APPX ODBC 5.5.2 gateway installer completes.
Figure 1. The matching APPX ODBC 5.5.2 gateway installer completes.
  1. Enter the APPX server's hostname and login-manager port. The example uses localhost and 31053. 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.
The matching 5.5.2 driver and ASQL installer completes.
Figure 3. The matching 5.5.2 driver and ASQL installer completes.
  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.