Tags:
view all tags
---+ 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. 1 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.* 1 Connect APPX/Windows to SQL Server following [[UsingAPPXODBCConnection][these instructions]]. 1 Now set up an APPX/Net connection between your APPX/Unix server and your APPX/Windows server following [[APPXNet][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 (<a href="https://www.progress.com/odbc/microsoft-sql-server" target="_blank" title="SQL Server ODBC Connector">SQL Server ODBC Connector</a>). 1 Install the unixODBC package from <a href="http://www.unixodbc.org/" target="_blank">unixODBC.org</a> 1 Install the Progress DataDirect SQL Server ODBC Connector ---++ Comments: _Read what other users have said about this page or add your own comments._ --- <br /><span data-mce-mark="1">%COMMENT%</span>
Edit
|
Attach
|
Watch
|
P
rint version
|
H
istory
:
r10
|
r5
<
r4
<
r3
<
r2
|
B
acklinks
|
V
iew topic
|
Raw edit
|
More topic actions...
Topic revision: r3 - 2015-12-18
-
JeanNeron
Home
Site map
Main web
MedicaidBilling web
Sandbox web
TWiki web
Main Web
Users
Groups
Index
Search
Changes
Notifications
RSS Feed
Statistics
Preferences
P
P
View
Raw View
Print version
Find backlinks
History
More topic actions
Edit
Raw edit
Attach file or image
Edit topic preference settings
Set new parent
More topic actions
Account
Log In
Edit
Attach
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki?
Send feedback