It's the "The remote procedure call failed and did not execute." error.
All information in the connection string is correct, and it sometimes connects, but most of the time it sits there for a few minutes and when you refresh it is gives the above error.

I am using an ADODB connection and the provider is OraOLEDB.Oracle.1
IIS server is W2k connecting to an Oracle 9 DB on a different machine.
I have MDAC 2.7 as well.

Someone please help me, this is holding up an entire project.