0 Replies Latest reply: Feb 8, 2006 1:16 PM by 487714 RSS

    OleDB not using OracleMTSRecoveryService?

    487714
      We have noticed that the OleDB provider is not using OracleMTSRecoveryService for transactions. We know this because we have:
      - Disabled OracleMTSRecoveryService
      - Dropped the MTSSYS user
      - Successfully ran multple transactions

      We are using a single application server that connects to a seperate database server.

      The Application Server has the following installed:
      - Oracle Administrative Client 9.2.0.4
      - Oracle Administrative Client 9.2.0.6 Upgrade
      - ODAC 9.2.0.7 Installed

      - The ConnectString for the application is 'Provider=OraOLEDB.Oracle.1;Data Source=LOADTEST;User ID=LoadUser;Password=;'

      - The HOME0, OLEDB, and OracleMTSRecoveryService register settings are set to the default. (ORAMTS_NET_CACHE_TIMEOUT is correctly set to 12000, not 120)

      Database Server:
      The SQL script was ran:
      - username: mtssys
      - password: mtssys
      - Net Connection name: Local (default, maybe this is the issue?)

      Just to confirm:
      OracleMTSRecoveryService runs on the application server only. It is not installed on the database server.

      Heh heh, K. So what am I missing?

      Thanks for your feedback!