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 JUNE 08, 2023
Applies to:
Oracle Database Gateway for SQL Server - Version 11.2.0.1 to 11.2.0.1 [Release 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
[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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |