Handling Distributed Transactions using Microsoft Transaction Server through Oracle Data Provider for .NET (ODP .NET)

• Objective of the Sample Application
• Overview of the Sample Application
• Screenshots with User Notes
• Required Software
• Extracting the Sample
• Database Setup
• Preparing and Running the Sample 
• Description of Sample files 

When this sample is run, an ASP.NET form with two Datagrids is displayed as shown in Figure 1.2. The first Datagrid contains data from Products table of Headquarters(HQ) database, and the second one contains data from Products table of the Regional database.

Figure 1.2, Screenshot displaying HQ and Regional Datagrids

To edit the price of products in HQ Datagrid, the user can click on 'EditRow' link for a product. The Datagrid appears in an editable mode, as shown in Figure 1.3.

Figure 1.3 Screenshot with HQ Datagrid in editable mode

On Clicking the update link the Products in HQ and Regional databases gets updated.

• Microsoft Internet Information Server (IIS) 5.0 or later, installed on Microsoft Windows 2000 environment with Service Pack 2 or later.

• Visual C# installed with MS Development Environment 7.0 version (MS Visual Studio .NET)  including MS .NET Framework 1.0 version

• Oracle8i Database or later running SQL*Net TCP/IP listener (can be downloaded here)

• Oracle Data Provider for .NET (ODP.NET) (can be downloaded here) with Microsoft Transaction Server Services installed.

Unzip DistributedTransactionSample.zip using Winzip or command utility to your convinent directory. Extraction of the zip file results  in the creation of DistributedTransactionSample directory. 

Connect to your database as any user and run the script DistributedTransactionSample\config\DatabaseSetup.sql
at the SQL prompt.

@<Extract_Dir>\DistributedTransactionSample\config\DatabaseSetup.sql

where <Extract_Dir> is the directory where you have extracted the sample.

The script creates two database users

• "hqodp" with password "hqodp"
• "regionodp" with password "regionodp"

This script creates the PRODUCTS table and populates the table with data.

Preparing and Running the Sample

Back To Top

1. Ensure that the Database setup has been completed. 

2. To publish your project from IIS, a virtual directory needs to be created. A virtual directory is a shared resource that is identified by an alias that represents a physical location on a server. Follow the steps to create a virtual directory for the sample.
   • Go to ControlPanel -> Administrative Tools -> Internet Service Manger -> Internet Information Services -> Default Web Site. Right click on Default Web Site -> New -> Virtual Directory.
   • A Virtual Directory Creation Wizard starts.
   • Give an alias for Web Virtual Directory. Click Next.
   • Enter the location as <Extract_Dir>\DistributedTransactionSample, to associate the given alias to this physical location. Click Next.
   • Ensure the Read, Run Scripts access permission are set for this virtual directory. Click Next.
   • This completes the creation of Virtual Directory.

3. Open Visual Studio .NET and to create a new web project. Click on File-> New->Project->Visual C# project->Empty Web Project, Give the project location mapping to your virtual directory (created in the previous step) .
   


4. To add the sample application files to your project, go to File -> Add Existing Item. In the File dialog select the sample files from <Extract_Dir>\DistributedTransaction\src\DistributedTransaction. Select all files and add them to your project.

5. Open Solution Explorer, Edit ConnectionParams.cs file located in <Extract_dir>\DistributedTransactionSample\src\DistributedTransactionSample folder to change the database connection parameters i.e.TNSName for databases in which you have created HQ and Regional schemas. Save this file.

6. Ensure that the following .NET Component References have been added to the project you have created:

   • System
   • System.Data
   • Oracle.DataAccess
   • System.Web
   • System.EnterpriseServices
   • System.XML
   • System.Drawing
   
   To add the above .NET Components 
   • Go to Menu -> View -> Solution Explorer.
   • Right click on the project you have created, choose 'Add Reference'.
   • Choose the above .NET Components from the list displayed.
   • Click 'Select', then OK.
   • The chosen .NET component gets added to the project. 
   
   
7. Copy DistributedTransaction.snk file available in <Extract_Dir>\DistributedTransactionSample\config directory to the directory containing your binary (dependent on your Visual Studio .NET configuration). For eg. <extract_dir>\<host_name>\DistributedTransactionSample\src\DistributedTransactionSample\obj\Debug

8. Build the sample and run the sample by clicking Debug->Start Without Debugging in Visual Studio .NET environment. Or manually run with the following URL in a web browser.
   http://<host-name>/<your-virtual-directory>/DistributedTransactionSample/productForm.aspx
   where <your-virtual-directory> is the alias name you had given for the physical mapping for your project. Refer step 2.

   For eg. http://152.69.170.237/<SampleCode>DistributedTransactionSample/productForm.aspx

Please enter your comments on this sample in OTN Sample Code Discussion Forum.