DG4MSQL HY000 Connection Fails and Gives Error General Error. Not TCP/IPServerName
(Doc ID 2021557.1)
Last updated on JULY 29, 2021
Applies to:
Oracle Database Gateway for SQL Server - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
You are using Database Gateway for SQL*Server (DG4MSQL) 11.2.0.4 to connect to a SQL*Server database and the connection fails.
A gateway trace shows the following error -
Entered hgopoer at 2015/06/17-10:51:59
hgopoer, line 231: got native error 0 and sqlstate HY000; message follows...
[Oracle][ODBC SQL Server Wire Protocol driver]General error. not TCP/IPServerName;TSTSQL;InstanceName;APPLICATION;IsClustered;No;Version;11.0.5058.0;np;\\TSTSQL\pipe\MSSQL$APPLICATZION\sql\query;; {HY000}
Exiting hgopoer, rc=0 at 2015/06/17-10:51:59
hgocont, line 2831: calling SqlDriverConnect got sqlstate HY000
Exiting hgocont, rc=28500 at 2015/06/17-10:51:59 with error ptr FILE:hgocont.c LINE:2851 ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2015/06/17-10:51:59 with error ptr FILE:hgolgon.c LINE:806 ID:Calling hgocont
Entered hgoexit at 2015/06/17-10:51:59
Exiting hgoexit, rc=0
hgopoer, line 231: got native error 0 and sqlstate HY000; message follows...
[Oracle][ODBC SQL Server Wire Protocol driver]General error. not TCP/IPServerName;TSTSQL;InstanceName;APPLICATION;IsClustered;No;Version;11.0.5058.0;np;\\TSTSQL\pipe\MSSQL$APPLICATZION\sql\query;; {HY000}
Exiting hgopoer, rc=0 at 2015/06/17-10:51:59
hgocont, line 2831: calling SqlDriverConnect got sqlstate HY000
Exiting hgocont, rc=28500 at 2015/06/17-10:51:59 with error ptr FILE:hgocont.c LINE:2851 ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2015/06/17-10:51:59 with error ptr FILE:hgolgon.c LINE:806 ID:Calling hgocont
Entered hgoexit at 2015/06/17-10:51:59
Exiting hgoexit, rc=0
The connect string in the gateway init<sid>.ora file is -
HS_FDS_CONNECT_INFO=[TSTSQL]/APPLICATION/TSTDB
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 |