Some more information
Os info: Linux dw-50.primed.com 2.6.18-164.15.1.el5PAE #1 SMP Mon Mar 1 11:14:09 EST 2010 i686 i686 i386 GNU/Linux
Oracle info: 10.2
Sql server: 2000/2005/2008
Error info: 10:01:12 Error: ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp: DB_ODBC_INTERFACE (819): ; [C078] Dynamic library '/usr/lib/libodbc.so' was not found
ORA-02063: preceding 2 lines from MS_PIMPROD
I removed all...and start from step one. using "the stable" freetds
then make sure that I have the proper link for libodbc.so:
ln -s /usr/local/lib/libodbc.so.1.0.0 /usr/lib/libodbc.so
everything is working fine now.
It is always better to ask a question like this in a new thread instead of adding to an existing one qwhich has been resolved. Very often upddates like this can be missed.
However, to connect from Oracle 11g to SQL*Server you can use one of the Oracle gateway products.
You coudl use either -
Database gateway for SQL*Server
Database Gateway for ODBC
The following notes in My Oracle Support have further information and discuss the differences between the 2 gateways -
Options for Connecting to Foreign Data Stores and Non-Oracle Databases (Doc ID 233876.1)
Functional Differences Between DG4ODBC and Specific Database Gateways (Doc ID 252364.1)
Gateway and Generic Connectivity Licensing Considerations (Doc ID 232482.1)
Please review this information and get back if you have any further questions, but as said, it would be btter to ask these in a new thread.