Results 1 to 4 of 4

Thread: MSDAORA and MTS

  1. #1
    Join Date
    Sep 2002
    Location
    Göteborg, Sweden
    Posts
    3

    Unanswered: 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!

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    If you are doing just a straight connection to oracle using ado without mts - is it slow ?

  3. #3
    Join Date
    Sep 2002
    Location
    Göteborg, Sweden
    Posts
    3
    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.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    What happens on subsequent connections ? Are you pooling your connections ? Can you try this on other databases (like sql server ) ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •