DG4MSQL Gives Error - SQL Server Does Not Exist or Access Denied - With NativeErr 17 and 67

(Doc ID 1482030.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

Using Dg4MSQL 11.2.0.3 to connect to SQL*Server gives the following error -

SQL> select * from "tabale_name"@sqlserver;
select * from "systables"@blaseserver
  *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access
denied. {08001,NativeErr = 17}[Oracle][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen (Connect()). {01000,NativeErr =
67}[Oracle][ODBC SQL Server Driver]Invalid connection string attribute {01S00}
ORA-02063: preceding 2 lines from SQLSERVER

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