View Full Version : MSDAORA and MTS
| 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 ) ?
vBulletin v3.5.3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.