2 Replies Latest reply: Sep 27, 2012 6:26 AM by 880492 RSS

    oracle to non-oracle connection

      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