MS SQL2000 Linked Server to Oracle 9i
Posted on 2004-08-11
I have seen the following answer to a question about liked server: "If you are using Oracle 9, you have to use Oracle's driver."
Can you please provide the exact prams needed to make the connections. Currently I am using the MSDAORA (Microsoft OLE DB) driver and I am doing inserts into oracle and the records are relatively small, but takes for ever to transfer data. Most of the time, if it goes longer than over night, I stop the transaction from processing and restart, but is not resolving the issue.
Your assistance is greatly appreciated.