Contents

Title and Copyright Information

Contact Us!

How to Contact Oracle Technical Publications

How to Contact Oracle Support Services

Resources for Oracle Partners and Developers

Before You Begin

Prerequisites

Intended Audience

How This Guide Is Organized

Documentation and Code Conventions Explained

1 Using Microsoft Transaction Server with an Oracle8 Database

Using Microsoft Transaction Server with an Oracle8 Database

What is Microsoft Transaction Server?

How are Microsoft Transaction Server and an Oracle8 Database Integrated?

How Do I Get Started?

2 Installing and Migrating Oracle Products

Oracle Product Layouts

What Do You Need to Install?

Migrating From a Previous Installation of Oracle Service for MTS

3 Creating a New Oracle Service for MTS

What Do You Need to Configure?

Verifying Initialization Parameter File Values

Verifying the Oracle Service for MTS User Name

Creating a New Oracle Service for MTS

4 Using the Microsoft Application Demo

Using OCI with the Microsoft Application Demo

Microsoft Application Demo Overview

Ensuring the Oracle8 Database Includes the Proper Tables

Running the Microsoft Application Demo

Using Oracle's ODBC Driver with the Microsoft Application Demo

5 Programming with Microsoft Transaction Server and an Oracle8 Database

Component Integration In a Transaction

Programming with Microsoft Transaction Server and an Oracle8 Database

Registering Microsoft Transaction Server Components

Components Running in a Microsoft Transaction Server-Coordinated Transaction

Components Not Running in a Microsoft Transaction Server-Coordinated Transaction, But Using MS DTC

Integrating OCI with Microsoft Transaction Server

OCI Function Overview

OraMTSSvcGet()

OraMTSSvcRel()

OraMTSSvcEnlist()

OraMTSSvcEnlistEx()

OraMTSTransTest()

OraMTSOCIErrGet()

Integrating ODBC with Microsoft Transaction Server

Setting the Connection Attribute

Using Oracle's ODBC Driver

Using Microsoft's Oracle ODBC Driver

Integrating Oracle Objects for OLE with Microsoft Transaction Server

Integrating Oracle Provider for OLE DB with Microsoft Transaction Server

Integrating Other APIs with Microsoft Transaction Server

6 Tuning Oracle Service for MTS Performance

Automatically Restarting Oracle Service for MTS

Improving Performance

Managing Connections

Increasing the Transaction Timeout Parameter

Changing Initialization Parameter File Settings

7 Troubleshooting

Using Trace Files

Correcting Windows NT Explorer Crashes

Identifying Oracle Service for MTS Startup Problems

Using the Event Viewer

Accessing the Event Viewer

Reading the Event Viewer

Using the Event Viewer

Starting MS DTC

Viewing Oracle Service for MTS Configuration Information

Correcting Net8 Changes that Impact Connection Pooling

Ensuring Oracle Service for MTS Connectivity and Security

Changing a Server Package's Windows NT User Account

Common Questions

A Manually Creating Oracle Service for MTS Users

Manually Creating the MTSSYS User

Manually Creating a Custom Oracle Service for MTS User

Creating a New Operating System-Authenticated Oracle Service for MTS

Enabling an Existing Oracle Service for MTS to be Operating System-Authenticated

B Deleting or Modifying an Existing Oracle Service for MTS

How Do I Modify or Delete an Oracle Service for MTS?

Preparing to Modify or Delete an Existing Oracle Service for MTS

Deleting an Existing Oracle Service for MTS

Modifying Oracle Service for MTS Connection Information

Modifying Oracle Service for MTS Trace File and MS DTC Information

Manually Deleting or Modifying the Oracle Service for MTS with the Registry

Deleting Roles and Privileges of an Inactive Oracle Service for MTS User

Index