ORA-28500:[ODBC SQL Server Legacy Driver][SQL Server]Cannot Open Database " " Requested By The Login

(Doc ID 2229402.1)

Last updated on FEBRUARY 10, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version to [Release 11.2 to 12.1]
Information in this document applies to any platform.


Using version 11.2.0.x and greater of Database Gateway for SQL Server DG4MSQL, the following error occurs when selecting SQl Server data

SQL> select sysdate from dual@SQLSERVERDPSSCG4DBP;
select sysdate from dual@SQLSERVERDPSSCG4DBP
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Legacy Driver][SQL Server]Cannot open database
"CG4-ATS" requested by the login. The login failed. {42000,NativeErr =
4060}[Oracle][ODBC SQL Server Legacy Driver]Invalid connection string attribute {01S00}
ORA-02063: preceding 2 lines from SQLSERVERDPSSCG4DBP


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