My Oracle Support Banner

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

Last updated on JANUARY 30, 2019

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.