Difference: ReadingSQLTablesfromAPPXUnix (4 vs. 5)

Revision 52015-12-22 - JeanNeron

 			 META TOPICPARENT 
			 name="APPXExternalDatabases" 
		
 Reading SQL/Server Tables from APPX/Unix
- META TOPICPARENT
+ name="APPXExternalDatabases"
 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>
->
>
+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>
LIBPATH=<path to the folder containing the Data Direct libraries>
-<
<
+These should be set in the .env file for the APPX Login Service, i.e.,
->
>
+These should be set in the $APPXPATH/appx.env file, 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
->
>
+#
# Progress Data Direct Setup
#
LIBPATH=/opt/Progress/DataDirect/Connect_for_ODBC_71/lib
APPX_ODBC_LIB=/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/odbc.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).
->
>
+NOTES: 
 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).
  Some versions of Unix use LIBPATH (i.e., AIX) and others use LD_LIBRARY_PATH. Set the appropriate variable for your system.
-<
<
+If you are running character mode terminals, you should set these in your 'appx.env' file in the $APPXPATH directory.
 Comments:
->
>
+ Troubleshooting 
 
 If you get the error "*Can't load ODBC driver manager" your library path is incorrect. Make sure you are using the correct environment variable (either LIBPATH or LD_LIBRARY_PATH) and that it points to a valid .so file.
 

Comments:
 Read what other users have said about this page or add your own comments.
-<
<
+  (Edit - Preview)
 
<--/commentPlugin-->
->
>
+  (Edit - Preview)
 
<--/commentPlugin-->
 \ No newline at end of file

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