Discussion:
[freetds] FreeTDS0.91 connection error
bico hamalah
2012-09-27 10:22:15 UTC
Permalink
I am able to connect through isql.

however, from oracle to ms sql through database link, i get:

SQL> SELECT * FROM Banks at EIMS;
SELECT * FROM Banks at 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
Frediano Ziglio
2012-10-09 17:15:18 UTC
Permalink
Post by bico hamalah
I am able to connect through isql.
SQL> SELECT * FROM Banks at EIMS;
SELECT * FROM Banks at EIMS
*
[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

Loading...