1 Using Microsoft Transaction Server with Oracle Database

This chapter describes Microsoft Transaction Server and Oracle Database integration.

This chapter contains these topics:

Microsoft Transaction Server Overview
Microsoft Transaction Server and Oracle Integration Overview
Getting Startedwith Microsoft Transaction Server and Oracle

1.1 Microsoft Transaction Server Overview

Microsoft Transaction Server is a proprietary component object model (COM) transaction processing system that runs on an Internet or network server. Microsoft Transaction Server deploys and manages application and database transaction requests on behalf of a client computer. Microsoft Transaction Server provides:

ActiveX/distributed component object model (DCOM) programming model to develop distributed applications and a runtime environment in which to deploy these applications.
Atomicity, Consistency, Isolation, and Durability (ACID) properties for components in transactions.
Access to performance-enhancing features such as component caching and database connection pooling.

Microsoft Transaction Server is a component of the three-tiered, server-centric architecture model. This model lets you separate the presentation, business logic, and data elements of applications onto different computers connected in a network. Microsoft Transaction Server functionality is also implemented in COM+ and Enterprise Services. Oracle Services for Microsoft Transaction Server, or OraMTS, support Microsoft Transaction Server, COM+, and Enterprise Services.

1.1.1 Oracle Services for Microsoft Transaction Server Support for Serializable Transactions

Oracle Services for Microsoft Transaction Server supports distributed transactions set to a serializable and read-committed isolation level.

1.1.2 Oracle Services for Microsoft Transaction Server Support for DTC

Oracle Services for Microsoft Transaction Server works with Microsoft Distributed Transaction Coordinator (DTC), which is part of the Enterprise Services component of .NET. DTC implements a two-phase commit protocol that makes sure that the transaction outcome is consistent across all data resources involved in a transaction.

1.2 Microsoft Transaction Server and Oracle Integration Overview

Without any special integration, you can deploy applications that were created using Win32, Win64, COM, or Microsoft .NET in a Microsoft Transaction Server that connects to an Oracle Database. To use either of the following features, however, you must install Oracle Services for Microsoft Transaction Server (OraMTS):

Register the Win32, Win64, COM or .NET application as transactional and have Microsoft Transaction Server control the transaction. You can do this by using the Properties dialog box of the component in the Microsoft Management Console Explorer.
Use client-side connection pooling in Microsoft Transaction Server.

After you have installed Oracle Services for Microsoft Transaction Server, an Oracle MTS Recovery Service is also automatically installed on the same computer. The Oracle MTS Recovery Service helps in the recovery of in-doubt transactions left in Oracle Database instances that originated from this computer. On each connected database:

Create the Microsoft Transaction Server administrator user account.
Schedule a database-level transaction recovery job.

This enables the database to participate in Microsoft Transaction Server-started transactions.

Create the COM component with any of the following Oracle products:

Oracle Call Interface (OCI)
Oracle Objects for OLE (OO4O)
Oracle Open Database Connectivity (ODBC) Driver
Oracle Provider for OLE DB
Access the Oracle Database using any .NET application using Oracle Data Provider for .NET (ODP.NET).

1.3 Getting Started with Microsoft Transaction Server and Oracle

You are now ready to use Microsoft Transaction Server with a database. To get started quickly, follow these steps:

Install the Oracle and Microsoft products required for Microsoft Transaction Server and database integration.

See Chapter 2, "Installing and Migrating Oracle Products".
Migrate from a previous release of Oracle Services for Microsoft Transaction Server.

See Chapter 2, "Installing and Migrating Oracle Products".
Create the Microsoft Transaction Server administrator user account.

See Chapter 3, "Managing Recovery Scenarios".
Schedule a Microsoft Transaction Server transaction recovery job.

See Chapter 3, "Managing Recovery Scenarios".
Run the Microsoft application demo.

See Chapter 4, "Running the Microsoft Application Demo" for information about running an application demo that:
- Uses transactional components hosted by Microsoft Transaction Server
- Accesses a database in a transaction controlled by Microsoft Transaction Server
Create Microsoft Transaction Server-hosted applications.

See Chapter 5, "Programming with Microsoft Transaction Server and an Oracle Database" for instructions on using OCI, OO4O, Oracle ODBC Driver, or Oracle Provider for OLE DB with COM-based applications.
Learn about using Microsoft Transaction Server on the different Windows operating systems.