Linking Oracle Servers

Has anyone successfully linked to a Linux Oracle server running 9i? We are unable to get the link working.....have installed various drivers and still get connection refused. Any thoughts?

Try to install oracle client on your machine,and it should work

Best Regards

|||

We have installed the client on the MS SQL server, installed Oracle OLE DB, etc. Still receive the error that we cannot initialize the MSDAORA. Not sure why. Using MS Access we are able to connect to the data via an ODBC connection (on the same box). However, we cannot use the ODBC to connect directly to the Oracle server (Oracle 9i on a Linux platform). Any other thoughts are appreciated.

|||Try to use Oracle ODBC driver instead of Microsoft ODBC for oracle (His name should be Oracle in <oraclehome>)