Usage Note 18351: Using SAS/ACCESS Interface to ODBC to access Progress SQL databases
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
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP3 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP3 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 SP3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP3 | |
| Linux | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP3 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP3 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP3 | |
| 64-bit Enabled AIX | 9.1 TS1M3 SP3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> LIBNAME Engines Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity)
|
| Date Modified: | 2008-03-04 15:21:11 |
| Date Created: | 2006-08-25 11:45:00 |