SUPPORT / SAMPLES & SAS NOTES
Problem Note 70924: The odbc.ini file included with SAS® Viya® 3.5 includes an invalid AuthenticationMethod for Greenplum
 |  |  |  |  |
Accessing Greenplum using the odbc.ini file that is included in the install might result in an error when the following is true:
- You are using SAS/ACCESS® Interface to Greenplum.
- You are running SAS® 9.4, SAS Viya 3.5, or the SAS® Viya® platform.
- You are using the Greenplum Driver 7.1.2 (S0gplm27.so) or later.
- You did not change the AuthenticationMethod option for Greenplum Wire Protocol in the sample odbc.ini file from the value of 1 to either 0 or 4.
The error might look similar to the following:
ERROR: CLI error trying to establish connection: [SAS][ODBC Greenplum Wire Protocol driver]The authentication type provided by driver, AM: 1, is not supported by this server
To resolve the issue, update the odbc.ini file and change the AuthenticationMethod for Greenplum to 0 or 4 (kerberos).
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
After application of the hot fix, the odbc.ini file has the AuthenticationMethod for Greenplum set to 0.
Fixed Versions
If you run SAS Viya 3.5, the hot fix on the Hot Fix tab of this note addresses the issue.
For the SAS Viya platform, the issue is fixed in SAS Viya Stable 2024.08.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Greenplum (on SAS Viya) | Linux for x64 | ||||
| SAS System | SAS/ACCESS Interface to Greenplum | Microsoft® Windows® for x64 | 9.4 | 9.4 TS1M0 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8 Pro x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 10 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 R2 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 R2 Std | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Std | 9.4 | 9.4 TS1M0 | ||||
| Windows 7 Enterprise x64 | 9.4 | 9.4 TS1M0 | ||||
| Windows 7 Professional x64 | 9.4 | 9.4 TS1M0 | ||||
| 64-bit Enabled AIX | 9.4 | 9.4 TS1M0 | ||||
| 64-bit Enabled Solaris | 9.4 | 9.4 TS1M0 | ||||
| HP-UX IPF | 9.4 | 9.4 TS1M0 | ||||
| Linux for x64 | 9.4 | 9.4 TS1M0 | ||||
| Solaris for x64 | 9.4 | 9.4 TS1M0 | ||||