APPX Version 5.4.2 and earlier

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).

Reading SQL/Server Tables from APPX/Unix

In order to access data stored under SQL Server under Windows while running APPX/Unix:

The configuration tasks are:

1. Install APPX on the NT box.

2. Copy from Unix to NT the Data Dictionary Design Files for the files you wish to store in SQL Server.

3. Set up the SQL Server based files in APPX on the NT box.

   ( This document explains how to configure APPX/NT to access SQL Server data).

4. Test the above and make sure it works on the NT box. (I.E., can you run a simple OUTPUT against the file and see the data?).

   If this does not work, open a DOS box on the NT server, set APPX_SQL_CMD=c:\sqlcmd.txt and APPX_DBG_CODE=0xFFFFFFFF,
   and invoke APPX directly (not with -c) from the console. Send us the resulting c:\sqlcmd.txt log.

Comments:

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

<--/commentPlugin-->