SAS does not certify against individual drivers or databases.  If the
vendor complies with the ODBC standard and has a 64-bit driver for
Progress SQL which are necessary for 64-bit Versions of SAS or a 32-bit
driver for 32-bit Versions of SAS then it should work with SAS/ACCESS
Interface to ODBC.  This is what is documented in the SAS System
Requirements.

Customers are responsible for determining if the ODBC driver they select
meets our system requirements.

We have customers using DataDirect drivers (of some version) on Windows
platforms accessing Progress SQL from SAS/ACCESS Interface to ODBC. We
are currently unaware of anyone accessing Progress SQL on Unix.

Internal knowledge base search returned the following information:

Statement from Progress in their knowledge base:

64-bit applications on 64-bit Operating Systems can not connect to a
Progress SQL-92 server through JDBC or ODBC.  32-bit applications on
64-bit Operating Systems can connect to a Progress SQL-92 server through
JDBC or ODBC.

To establish this type of connection from a 64-bit application you
require either a 64-bit ODBC or JDBC driver. 64-bit drivers are not
available with the Progress 9.1x or 10.x releases, only 32-bit drivers
are provided.

Customers planning to use (or using) an application on 64-bit Operating
Systems where the Progress JDBC and/or ODBC drivers for SQL-92 are
available need to ensure that they will be (or are) using a 32-bit
application.

The only exception to this is Compaq Tru64, whereby there is a 64-bit
JDBC driver (no ODBC driver).


Another internal search provided the following information.

PROBLEM:
Issues to set up access to Progress OpenEdge 9.1D via ODBC with SAS
9.1.3 on AIX 5.3.

RESOLUTION:
SAS 9.1.3 64-bit can only work with 64-bit ODBC drivers, and the
Progress 9.1x or 10.x releases only provide 32-bit drivers.

Possible workarounds:

- If customer has a Windows box somewhere with a Progress ODBC data
  source defined, they can use SAS/ACCESS Interface to PC File object on
  UNIX to connect to the server component on Windows which then fetches
  data via ODBC. (Please beware that performance can be an issue with
  this method).

- Have a 32 bit SAS 8.2 interfacing with 32 bit ODBC and feed the data
  back to SAS 9.1.3.

- Set up procedure to dump Progress data into flatfiles.

Operating System and Release Information