My Oracle Support Banner

DG4MSQL Gives Error - SQL Server Does Not Exist or Access Denied - With NativeErr 17 and 67 (Doc ID 1482030.1)

Last updated on SEPTEMBER 23, 2021

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 "table_name"@sqlserver;
select * from "table_name"@sqlseserver
  *
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

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


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