11.2 DG4MSQL Gives Error ORA-28500 {08S01,NativeErr = 11} with SQL Server SSL Encryption Enabled (Doc ID 1448437.1)

Last updated on MAY 20, 2016

Applies to:

Oracle Database Gateway for SQL Server - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms


When using Database Gateway for SQL Server (DG4MSQL) 11.2. to connect to a SQL Server database that has SSL Encryption enabled, the following error occurs:

SQL> select sysdate from dual@dblink;
select sysdate from dual@dblink
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver][libssclient24]General network error. Check
your network documentation. {08S01,NativeErr = 11}[Oracle][ODBC SQL Server
Driver][libssclient24]ConnectionRead (recv()). {01000,NativeErr =
11}[Oracle][ODBC SQL Server Driver]Invalid connection string attribute {01S00}
ORA-02063: preceding 2 lines from DBLINK
You might also see the following in the gateway trace file:

Entered hgopoer at 2015/01/21-16:25:32
hgopoer, line 231: got native error 0 and sqlstate 08S01; message follows...
[Oracle][ODBC SQL Server Wire Protocol driver]Socket closed. {08S01}
Exiting hgopoer, rc=0 at 2015/01/21-16:25:32
hgocont, line 2831: calling SqlDriverConnect got sqlstate 08S01

and on SQL*Server side -

Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library. [CLIENT: <gateway_ip_address>]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms