Difference: ReadingSQLTablesfromAPPXUnix (3 vs. 4)

Revision 42015-12-21 - JeanNeron

 			 META TOPICPARENT 
			 name="APPXExternalDatabases" 
		
 Reading SQL/Server Tables from APPX/Unix
- META TOPICPARENT
+ name="APPXExternalDatabases"
  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).
->
>
+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.
-<
<
+ Install the unixODBC package from unixODBC.org
  Install the Progress DataDirect SQL Server ODBC Connector
->
>
+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.
-<
<
+  (Edit - Preview)
 
<--/commentPlugin-->
->
>
+  (Edit - Preview)
 
<--/commentPlugin-->

View topic | History: r10 < r9 < r8 < r7 | More topic actions...