My Oracle Support Banner

DG4MSQL HY000 Connection Fails and Gives Error General Error. Not TCP/IPServerName (Doc ID 2021557.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database Gateway for SQL Server - Version and later
Information in this document applies to any platform.


You are using Database Gateway for SQL*Server (DG4MSQL) 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


The connect string in the gateway init<sid>.ora file is -




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.