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).
A hot fix is planned for the issue.
After application of the hot fix, the odbc.ini file will now have the AuthenticationMethod for Greenplum set to 0.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Greenplum (on SAS Viya) | Linux for x64 | Viya | |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2024-08-09 15:38:38 |
| Date Created: | 2024-08-07 16:07:08 |