My Oracle Support Banner

ORA-28500:[ODBC SQL Server Legacy Driver][SQL Server]Cannot Open Database " " Requested By The Login (Doc ID 2229402.1)

Last updated on MAY 11, 2022

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


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

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