Re: FreeTDS0.91 connection error

Frediano Ziglio <[email protected]> Tue, 9 Oct 2012 18:15:18 +0100

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<CAHt6W4eii8CaYARLa0PHXQMN7U_1KUH6cGHd7Rprn+G1biZa=A@mail.gmail.com>

2012/9/27 bico hamalah <[email protected]>:
> I am able to connect through isql.
>
> however, from oracle to ms sql through database link, 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

Which server are you trying to connect to?
Usually this could happen if you are using the wrong protocol version?
Which settings are you using in Oracle?
Are you using the same unix account?

Frediano