We have a problem using Microsofts OLE DB Provider for Oracle together with ADO and MTS. Connecting to Oracle (oConn.Open "...") in a transact component takes a long time, about 10-15 seconds. The actual statement executed on the connection later executes very fast.

If you have experienced something similar or know something about this problem, I would be very grateful if you helped me out!

If you are doing just a straight connection to oracle using ado without mts - is it slow ?

I have tried the same connection from a stand alone VB exe and it is very quick. My best guess (so far!) is that the DTC is somehow involved in the performance problems.

What happens on subsequent connections ? Are you pooling your connections ? Can you try this on other databases (like sql server ) ?