Problem Note 70984: Unable to connect to a database when using a DataDirect ODBC driver and SSL is needed
 |  |  |  |  |
When using SAS/ACCESS® Interface to Amazon Redshift, SAS/ACCESS® Interface to Greenplum, or SAS/ACCESS® Interface to Microsoft SQL Server, one of the following errors might occur:
ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Wire Protocol driver]Unable to dynamically load client DLL S0openssl30.so.: [SAS][ODBC SQL Server Wire Protocol driver]SSL Initialization
or
[SAS][ODBC SQL Server Wire Protocol driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
To work around this issue, you can modify your ODBC DSN by setting the following options:
SSLLibName=<path to>/libssl3.so
CryptoLibName=<path to>/libcrypto3.so
CryptoLibName=<path to>/libcrypto3.so
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Greenplum | 64-bit Enabled AIX | 9.4 TS1M8 | |
| 64-bit Enabled Solaris | 9.4 TS1M8 | |||
| HP-UX IPF | 9.4 TS1M8 | |||
| Linux for x64 | 9.4 TS1M8 | |||
| Solaris for x64 | 9.4 TS1M8 | |||
| SAS System | SAS/ACCESS Interface to Microsoft SQL Server | 64-bit Enabled AIX | 9.4 TS1M8 | |
| 64-bit Enabled Solaris | 9.4 TS1M8 | |||
| HP-UX IPF | 9.4 TS1M8 | |||
| Linux for x64 | 9.4 TS1M8 | |||
| Solaris for x64 | 9.4 TS1M8 | |||
| SAS System | SAS/ACCESS Interface to Amazon Redshift | 64-bit Enabled AIX | 9.4 TS1M8 | |
| 64-bit Enabled Solaris | 9.4 TS1M8 | |||
| HP-UX IPF | 9.4 TS1M8 | |||
| Linux for x64 | 9.4 TS1M8 | |||
| Solaris for x64 | 9.4 TS1M8 | |||
A fix for this issue for DataDirect ODBC Driver for Microsoft SQL Server 9.45 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M2L.html#70984A fix for this issue for DataDirect ODBC Driver for Amazon Redshift 9.45 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M2D.html#70984A fix for this issue for DataDirect ODBC Driver for Greenplum 9.45 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M9F.html#70984| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-10-10 12:12:52 |
| Date Created: | 2024-10-03 16:07:32 |