This discussion is archived
0 Replies Latest reply: Feb 8, 2006 11:16 AM by 487714 RSS

OleDB not using OracleMTSRecoveryService?

487714 Newbie
Currently Being Moderated
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!