Reading SQL/Server Tables from APPX/Unix

In order to access data stored under SQL Server under Windows while running APPX/Unix you have 2 choices, depending on which version of APPX you are currently running.

APPX Version 5.4.2 and earlier

The technique is to install a copy of APPX for Windows and connect it to SQL Server in the usual way. Once that is working, then use APPX/Net to connect your APPX Unix server to your APPX/Windows server. When APPX/Unix access the data over APPX/Net, the APPX/Windows server will retrieve it from SQL Server.

1. Install APPX on a Windows server.
2. Copy the application from Linux/Unix to Windows. Note that if you are copying from AIX, HP or Sun you must export your design files and import them into the Windows server. Linux Application Files are binary compatible with Windows, so you can just copy the Application Design files directly. We only need the Data Dictionaries for the file(s) you want to access, alternatively you can just manually enter the Data Dictionary in APPX/Windows if that's easier. You must keep the Data Dictionary in sync between APPX/Windows and APPX/Unix.
3. Connect APPX/Windows to SQL Server following these instructions.
4. Now set up an APPX/Net connection between your APPX/Unix server and your APPX/Windows server following these instructions

APPX Version 5.4.3 and higher

APPX Version 5.4.3 has been tested with the DataDirect SQL Server ODBC connector from Progress Software (SQL Server ODBC Connector). The connector is available in both 32 bit and 64 bit versions, make sure you install the version that matches your APPX version. If you are not sure if APPX is 32 bit or 64 bit, then it is probably 32 bit.

After installing and testing the connector, you must set the following environment variables in APPX:

APPX_ODBC_LIB=<path to the Progress supplied libodbc shared library>
ODBCINI=<path to your odbc.ini file>
ODBCINST=<path to your odbcinst.ini file>

These should be set in the .env file for the APPX Login Service, i.e.,

# Appx connection manager environment variables
#
# The entries in this file will become
# environment variables in the engines
# spawned by this service
#
# blank lines are ignored
#
# anything following a '#' is treated as a comment
#
# letter case IS important in this file
# -------------------------------------------------- 
APPX_ODBC_LIB=/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/libodbc.so
ODBCINI=/opt/Progress/DataDirect/Connect_for_ODBC_71/odbc.ini
ODBCINST=/opt/Progress/DataDirect/Connect_for_ODBC_71/odbcinst.ini

Don't forget to restart your service after making these changes. NOTE: if your ODBC Connector does not have a 'libodbc.so' file in the lib folder, check for an 'odbc.so' file and use it instead (this seems to be the case on AIX).

If you are running character mode terminals, you should set these in your 'appx.env' file in the $APPXPATH directory.

Comments:

Read what other users have said about this page or add your own comments.