Usage Note 60486: When you use SAS/ACCESS® Interface to ODBC to connect to a Denodo database, "...invalid connection option 'krbsrvname'..." occurs
 |  |  |  |
When using SAS/ACCESS Interface to ODBC to connect to Denodo, you might receive the following error:
libname test odbc datasrc="Denodo" user=xxxxxx password="XXXXXX" schema=dba;
ERROR: CLI error trying to establish connection: [unixODBC]invalid connection option "krbsrvname"
ERROR: Error in the LIBNAME statement.
ERROR: Error in the LIBNAME statement.
You encounter this problem when the Postgres database that Denodo uses is an older version of Postgres. The problem occurs even when ISQL can connect to the Denodo system.
To circumvent the problem, update Postgres to version 9.4 rather than version 8 or earlier versions.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | 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 | ||||
When using SAS/ACCESS Interface to ODBC to connect to a Denodo database, you might receive KRBSRVNAME errors. The problem occurs when the Postgres database on which Denodo resides is out of date. To circumvent the problem, update the Postgres database to Version 9.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2017-06-23 09:53:19 |
| Date Created: | 2017-05-17 12:24:22 |