Errors ORA-28500, NativeErr = 11 and SQLSTATE 1 Using DG4MSQL 11.2.0.1 on HP-UX Itanium (Doc ID 1354802.1)

Last updated on JANUARY 09, 2017

Applies to:

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

Symptoms


You are running DG4MSQL 11.2.0.1 on HP-UX Itanium 11.31 to connect to SQL*Server 2008 and get the following error -

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Serv {1}[Oracle][ODBC SQL Server Driver][libssclient24]
{ime,NativeErr = 11}[Oracle][ODBC SQL Server
Driver][libssclient24]ConnectionOpen (machine.oracle.com()).
{01000,NativeErr = 11}[Oracle][ODBC SQL Serv {1}
ORA-02063: preceding 2 lines from GATEWAY_LINK


A DG4MSQL debug trace shows the following -

Entered hgopoer at 2011/09/01-09:17:34
hgopoer, line 231: got native error 0 and sqlstate 1; message follows...
[Oracle][ODBC SQL Serv {1}[Oracle][ODBC SQL Server Driver][libssclient24] {ime,NativeErr = 11}[Oracle][ODBC SQL Server Driver][libssclient24]ConnectionOpen (machine.oracle.com()). {01000,NativeErr = 11}[Oracle][ODBC SQL Serv {1}
Exiting hgopoer, rc=0 at 2011/09/01-09:17:34
hgocont, line 2754: calling SqlDriverConnect got sqlstate 1
Exiting hgocont, rc=28500 at 2011/09/01-09:17:34 with error ptr FILE:hgocont.c LINE:2774 ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2011/09/01-09:17:34 with error ptr FILE:hgolgon.c LINE:790 ID:Calling hgocont
Entered hgoexit at 2011/09/01-09:17:34
Exiting hgoexit, rc=0


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