Difference: ReadingSQLTablesfromAPPXUnix (5 vs. 6)

Revision 62016-01-04 - JeanNeron

Line: 1 to 1

META TOPICPARENT	name="APPXExternalDatabases"

Reading SQL/Server Tables from APPX/Unix

Line: 14 to 14

APPX Version 5.4.3 and higher

Changed:

<
<

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.

>
>

APPX Version 5.4.3 has been tested with the DataDirect SQL Server ODBC connector from Progress Software (SQL Server ODBC Connector) and the ODBC Driver from EasySoft.

DataDirect

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.

After installing and testing the connector, you must set the following environment variables in APPX:

Line: 24 to 27

#
# 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

Added:

>
>

Once you have a working connection, then configure the APPX ODBC connection as usual.

NOTES:

Changed:

<
<

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 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.

Added:

>
>

EasySoft SQL Server ODBC Driver

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.

Added:

>
>

Once you have a working connection, then configure the APPX ODBC connection as usual.

Troubleshooting

Changed:

<
<

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.

>
>

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.

Changed:

<
<

Comments:

>
>

Comments:

Read what other users have said about this page or add your own comments.

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