SUPPORT / SAMPLES & SAS NOTES
 

Support

Installation Note 38046: An error occurs when you try to connect to a Greenplum database via SAS/ACCESS® Interface to Greenplum

DetailsHotfixAboutRate It

Without the DataDirect ODBC Driver for Greenplum, you cannot connect to Greenplum databases by using SAS/ACCESS Interface to Greenplum. In the second and thrid maintenance release for SAS 9.2 (TS2M2 and TS2M3), that driver is not available when you install and configure SAS/ACCESS Interface to Greenplum. As such, if you try to connect to a Greenplum database after you install SAS/ACCESS Interface to Greenplum, you will receive an error message similar to the following:

ERROR: The SAS/ACCESS Interface to GREENPL cannot be loaded. 
The SASGPL code appendage could not be loaded. 
ERROR: Error in the LIBNAME statement.

Click the Hot Fix tab in this note to access the hot fix which supplies the DataDirect ODBC Driver for Greenplum.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ACCESS Interface to GreenplumSolaris for x649.219.39.2 TS2M29.3 TS1M0
Linux for x649.219.39.2 TS2M29.3 TS1M0
Linux9.219.39.2 TS2M29.3 TS1M0
HP-UX IPF9.219.39.2 TS2M29.3 TS1M0
64-bit Enabled Solaris9.219.39.2 TS2M29.3 TS1M0
64-bit Enabled AIX9.219.39.2 TS2M29.3 TS1M0
Microsoft Windows XP Professional9.219.39.2 TS2M29.3 TS1M0
Microsoft® Windows® for x649.219.39.2 TS2M29.3 TS1M0
* 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.