Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
Reading SQL/Server Tables from APPX/Unix | ||||||||
Line: 25 to 25 | ||||||||
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> | ||||||||
Added: | ||||||||
> > | If you aren't sure what the APPX_ODBC_LIB path should be, check the 'odbc.ini' file and use the path indicated by the 'Driver' line. The other variables also set during the DataDirect installation, you should be able to determine their values from that step. | |||||||
These should be set in the $APPXPATH/appx.env file, i.e.,
# # 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 | ||||||||
Line: 32 to 34 | ||||||||
Once you have a working connection, then configure the APPX ODBC connection as usual. NOTES: | ||||||||
Deleted: | ||||||||
< < |
| |||||||
EasySoft SQL Server ODBC DriverThe 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. | ||||||||
Changed: | ||||||||
< < | The EasySoft driver does not include the unixODBC driver manager software, you must install that first from unixODBC.org. Make sure you can establish your connection using 'isql' before trying to connect via APPX. | |||||||
> > | The EasySoft driver may not include the unixODBC driver manager software. If not, you must install that first from unixODBC.org. Make sure you can establish your connection using 'isql' before trying to connect via APPX.
After installing and testing the connector, you must set the following environment variable in APPX:
APPX_ODBC_LIB=<path to the shared library>
If you aren't sure what the APPX_ODBC_LIB path should be, check the 'odbcinst.ini' file and use the path indicated by the 'Driver' line.
These should be set in the $APPXPATH/appx.env file, i.e.,
# # EasySoft Driver Setup # APPX_ODBC_LIB=/usr/local/easysoft/sqlserver/lib/libessqlsrv.so | |||||||
Once you have a working connection, then configure the APPX ODBC connection as usual.
Troubleshooting | ||||||||
Changed: | ||||||||
< < |
| |||||||
> > |
| |||||||
| ||||||||
Line: 50 to 61 | ||||||||
Read what other users have said about this page or add your own comments.
| ||||||||
Deleted: | ||||||||
< < | ||||||||
\ No newline at end of file | ||||||||
Added: | ||||||||
> > |