4 Running the Microsoft Application Demo

Microsoft Application Demo Overview

The Microsoft application demo is installed in the ORACLE_BASE\ORACLE_HOME\oramts\samples\account.vc directory and is an OCI implementation of the Visual C++ Sample Bank package that ships with Microsoft Transaction Server. The demo component uses the user account scott and password tiger to connect to a database whose net service name is mtsdemo. You can change this information in the oramisc.h file. The demo also uses two tables:

• account

• receipt

These tables are part of the user scott schema in the default Oracle database created during installation.

Ensuring the Database Includes the Proper Microsoft Application Demo Tables

If the default database is not being used or the database does not include the user scott, create the tables required to run the sample banking Microsoft application demo in the relevant user's schema.

To ensure the database includes the proper tables:

1. Review the following table to determine if the database includes the proper tables:

   If You Create the Database Through These Methods...	Then...
   Through the General Purpose, Transaction Processing, or Data Warehouse database configuration type of Oracle Universal Installer or Database Configuration Assistant Manually using a custom SQL script, and then explicitly run the scott.sql and omtssamp.sql scripts in that order against the database Note: If you run omtssamp.sql before running scott.sql, you receive numerous error messages. Ignore these messages. The product functions properly, but the sample application demo described in this chapter does not work.	The database includes the proper tables. Go to "Running the Microsoft Application Demo".
   Manually using a custom SQL script, and do not run omtssamp.sql against the database Using the CREATE DATABASE syntax in SQL*Plus line mode In any available method on Solaris or any other operating system	The database does not include the proper tables. Perform steps 0 through 6 in this section before proceeding to "Running the Microsoft Application Demo".

   
   

If the database does not include the proper tables, you must create them manually.

To manually create the proper tables:

1. Start SQL*Plus:

   C:\> sqlplus /NOLOG
   
   

2. Connect to the database:

   SQL> CONNECT username/password@net_service_name
   
   

   where net_service_name is the net service name that connects to the database. If you connect to the database with a username other than scott, you must change the username and password in oramisc.h and rebuild vcacct.dll.

3. Create the user mtsdemousr:

   SQL> CREATE USER mtsdemousr IDENTIFIED BY mtsdemousr; 
   
   

   This creates the user mtsdemousr, which runs the Microsoft sample application.

4. Assign the following roles to user mtsdemousr:

   SQL> GRANT CONNECT,RESOURCE TO mtsdemousr;
   
   

5. Connect with user mtsdemousr:

   SQL> CONNECT mtsdemousr/mtsdemousr@net_service_name
   
   

6. Run the following SQL script:

   SQL> @ORACLE_BASE\ORACLE_HOME\oramts\samples\sql\omtssamp.sql
   
   

   This creates the account and receipt tables in the schema of user mtsdemousr.

Running the Microsoft Application Demo

This section describes how to run the Microsoft application demo.

To run the Microsoft application demo:

1. Ensure that you have installed the Sample Bank Client application shipped with Microsoft Transaction Server. The sample component DLLs are typically installed under ROOTDRIVE:\program files\mts\samples\packages.

2. Open the project account.dsp in the ORACLE_BASE\ORACLE_HOME\oramts\SAMPLES\account.vc\Release directory using Microsoft Developer Studio.

3. Build vcacct.dll.

4. Back up the file vcacct.dll installed under ROOTDRIVE:\program files\mts\samples\packages.

5. Overwrite vcacct.dll with the one you built in step 3.

6. Choose Start > Programs > Windows NT 4.0 Option Pack > Microsoft Transaction Server > Bank Client.

   This starts the Sample Visual Basic bank application and runs vbbank.exe to test the component.

7. Click the Visual C++ radio button of the Language field.

8. Click the Account or the MoveMoney radio boxes under the Component field.

9. Enter the account numbers and the amount for the operation.

10. Click Submit.

11. Start SQL*Plus:

    C:\> sqlplus /NOLOG
    
    

12. Connect with the username scott and the password tiger (unless you changed it):

    SQL> CONNECT scott/tiger
    
    

13. Verify the success of the operation:

    SQL> SELECT * FROM account; 
    SQL> SELECT * FROM receipt;