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.
- Install APPX on a Windows server.
- 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.
- Connect APPX/Windows to SQL Server following these instructions.
- 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).
Comments:
Read what other users have said about this page or add your own comments.