|Oracle Developer's Guide for Microsoft Transaction Server
Release 9.0.1 for Windows
Part Number A90170-01
This chapter contains these topics:
You can use the Oracle Call Interface (OCI) with the sample banking application demo that Microsoft provides with Microsoft Transaction Server. In most cases, OCI is automatically integrated with the Microsoft application demo. Review Table 4-1 to determine if OCI and the Microsoft application demo are integrated, and what you can do if they have not been integrated.Table 4-1 Verifying OCI and Microsoft Application Demo Integration
|If Microsoft Transaction Server...||Then...|
Is already installed when you install Oracle Services for Microsoft Transaction Server
Oracle Universal Installer automatically backs up and substitutes several Visual C++ files of the banking demo with files that integrate the
Perform the following procedures:
The Microsoft application demo is installed in the
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:
These tables are part of the user
scott schema in the default Oracle database server created during installation. See "Ensuring the Database Includes the Proper Microsoft Application Demo Tables" for more information.
If the default database server is not being used or the database server 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 server includes the proper tables:
|If You Create the Database Server Through These Methods...||Then...|
The database server includes the proper tables. Go to "Running the Microsoft Application Demo".
If you run |
If the database server does not include the proper tables, you must create them manually.
To manually create the proper tables:
net_service_name is the net service name that connects to the database server. If you connect to the database server with a username other than
scott, you must change the username and password in
oramisc.h and rebuild
This creates the user
mtsdemousr, which runs the Microsoft sample application.
This creates the
receipt tables in the schema of user
This section describes how to run the Microsoft application demo.
To run the Microsoft application demo:
The sample project was created using Visual C++ 5.0. To build the project using Visual C++ 6.0, the Microsoft
When opening a Visual C++ 5.0 project, Visual C++ 6.0 automatically updates it to the new release.
program files\mts\samples\packages. You can also verify installation through the Control Panel:
The Add/Remove Programs Properties dialog box appears.
The setup takes several seconds to initialize. When complete, the Microsoft Windows NT 4.0 Option Pack Setup dialog box appears.
Installation takes several seconds.
oramts\samples\account.vcdirectory using Microsoft Developer Studio.
vcacct.dllwith the one you built in step 3.
This starts the Sample Visual Basic bank application and runs
vbbank.exe to test the component.
tiger(unless you changed it):
You can use Oracle Open Database Connectivity (ODBC) Driver release 9.0 with the Microsoft sample application. See "Using the Oracle ODBC Driver" for instructions on integrating the Oracle ODBC Driver with the sample application.
You can use Oracle Provider for OLE DB release 9.0 with the Microsoft sample application. See the Oracle Provider for OLE DB Developer's Guide for information about using Oracle Provider for OLE DB with Microsoft Transaction Server.