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 laterInformation 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 |