|Oracle® Services for Microsoft Transaction Server Developer's Guide
10g Release 1 (10.1) for Windows
Part Number B10114-01
This chapter describes Microsoft Transaction Server and Oracle database integration.
This chapter contains these topics:
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 the following:
An 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 to 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 enables the presentation, business logic, and data elements of applications to be clearly separated onto different computers connected in a network. Microsoft Transaction Server functionality was later implemented in COM+ and Enterprise Services. Microsoft Transaction Server, COM+, and Enterprise Services are supported by Oracle Services for Microsoft Transaction Server.
See Also:Microsoft documentation for additional information about Microsoft Transaction Server
Without any special integration, you can deploy a COM component or Microsoft .NET application in 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 COM component or .NET application as transactional (using the Properties dialog box of the component in the Microsoft Management Console Explorer) and have Microsoft Transaction Server control the transaction
Use client-side connection pooling in Microsoft Transaction Server
After Oracle Services for Microsoft Transaction Server is installed, 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 databases that originated from this computer. On each connected database perform the following:
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:
Access the Oracle database using any .Net application using Oracle Data Provider for .NET (ODP.NET).
Additional application programmatic interfaces (APIs) may be integrated in the future.
You are now ready to use Microsoft Transaction Server with a database. To get started quickly, follow the chapters identified in Table 1-1 in the order listed.
Table 1-1 Getting Started with Microsoft Transaction Server and Oracle
|To Perform The Following Task...||See...|
||Chapter 2, " Installing and Migrating Oracle Products "|
||Chapter 3, " Managing Recovery Scenarios"|
|Run the Microsoft application demo.||Chapter 4, " Running the Microsoft Application Demo " for information about running an application demo that:
|Create Microsoft Transaction Server-hosted COM applications.||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.||Appendix A, " Using Oracle Services for Microsoft Transaction Server on Windows Operating Systems"|