Linked Servers to Oracle 9i
Posted on 2005-05-02
I have been running a linked server connection between SQL 2000 and Oracle 8 for 2 years without a hitch.
Well, be except the registery change you do to make it work...lol.
With little warning, the Oracle DBA upgraded to Orcale 9i, ever since dts's that ran 20 minutes now time out at 90 hours at times.
I have loaded the 9i drivers but I can not find any documentation to complete the changes over.
I had read that 9i drivers weren't fully supported yet bit that had changed recently.
Is there another registery change I need to do?