This discussion is archived
2 Replies Latest reply: Sep 27, 2012 4:26 AM by 880492 RSS

oracle to non-oracle connection

880492 Newbie
Currently Being Moderated
I have unixodbc and freetds. from isql i can connect to ms sql server. From oracle sqlplus i get:

SQL> SELECT * FROM "Banks"@EIMS;
SELECT * FROM "Banks"@EIMS
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][FreeTDS][SQL Server]Unable to connect to data
source[unixODBC][FreeTDS][SQL Server]Adaptive Server connection
failed[unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server
ORA-02063: preceding 2 lines from EIMS

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points