Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error when connecting to sql server database from oracle

user8792751Feb 2 2012 — edited Feb 3 2012
iam getting the below error when i tried to connect to sql server.
SQL> select * from sys.tables@mssql
  2  / 
select * from sys.tables@mssql
                         *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver][DBNETLIB]Invalid connection. {08001,NativeErr
= 14}[Oracle][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(ParseConnectParams()). {01000,NativeErr = 14}[Oracle][ODBC SQL Server
Driver]Invalid connection string attribute {01S00}
ORA-02063: preceding 2 lines from MSSQL
What coulds be the reason for this error.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2012
Added on Feb 2 2012
11 comments
2,205 views