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

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.2.0.4 and later
Information 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

 

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

HS_FDS_CONNECT_INFO=[TSTSQL]/APPLICATION/TSTDB

 

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