If you are using SAS/ACCESS^® Interface to PostgreSQL and the driver that shipped with your SAS software, you might receive an error when you try to enable SSL. The errors shown below occur if your PostgreSQL database requires a Secure Sockets Layer (SSL) connection:

The problem occurs because the driver that is currently shipped with the SAS software does not support SSL.

Workaround

1. Contact SAS Technical Support for the latest available SSL enabled driver. Then, upgrade your current driver.
2. Once you have downloaded and installed the new drivers, use either a LIBNAME or ODBC DSN option to specify which SSL mode to use.
    
   • To specify the SSLMODE parameter in a LIBNAME option, use the CONOPTS= option:
     libname mypost postgres server="server-name" port=5432 database=db-name
     user=user-ID password=password schema=schema conopts="sslmode=require";
   • Or, to specify in an ODBC DSN file, add SSLmode=require under the ODBC DSN entry that you want to be SSL enabled.

This link, SSL Support, provides more information about PostgreSQL SSL and values that can be used with the SSLMODE parameter. Consult your PostgreSQL database administrator about which value you should enter if SSL is enabled.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS/ACCESS Interface to PostgreSQL	64-bit Enabled Solaris	9.4		9.4 TS1M2
		HP-UX IPF	9.4		9.4 TS1M2
		Linux for x64	9.4		9.4 TS1M2
		Solaris for x64	9.4		9.4 TS1M2

* 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.

---

The driver that is currently shipped with your SAS software does not support SSL. A new driver with SSL support for PostgreSQL ODBC drivers is available for download.

Type:	Problem Note
Priority:	medium
Topic:	Data Management ==> Data Sources ==> External Databases ==> PostgreSQL

Date Modified:	2023-01-31 07:47:21
Date Created:	2014-09-22 13:38:43