How to Connect to SQL*Server Using Dg4MSQL When The Instance Has A Slash In the Name ? (Doc ID 1527322.1)

Last updated on NOVEMBER 08, 2013

Applies to:

Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Check for relevancy Nov 8 2013

Goal

How can I connect to SQL*Server using  Oracle Database Gateway for SQL*Server (DG4MSQL) when the SQL*Server instance has a slash in the name ?
The following syntax in the gateway init<sid>.ora file -

HS_FDS_CONNECT_INFO="RMBSDR/RMBSDR//RMBSAnalytics"

 or

HS_FDS_CONNECT_INFO="RMBSDR/[RMBSDR]/RMBSAnalytics"

 

 results in an ORA-28500 error.

 

How do I code the SQL Server instance name in the HS_FDS_CONNECT_INFO parameter ?

 

 

 
 

Solution

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