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
Please post the odbc.ini file you're using.
It might look like that the wrong TDS protocol version is being used with Dg4ODBC and FreeTDS.
Edited by: kgronau on Sep 27, 2012 12:47 PM
TDS_Version = 8.0
to your odbc.ini