Software Requirements  :
 
 1. NT 4.0 OS/Win2000.
 2. MTS Explorer(Which comes as a NT4 Option Pack,which is downloadable from www.mirosoft.com).
 3. Visual Basic 6.0.
 4. GBASEDBT CSDK.
 5. GBasedbt Server(IDS).

 
Before running the "Client.exe" you have to install the MTS component.

Now How to install MTS Component(In this case its Server.dll)?

Step 1 :  Install the NT4 Option Pack(which you have downloaded).If its not already installed.

step 2 :  Go to Start->Programs->Windows NT 4.0 Option Pack->Microsoft Transaction Server---
          -->Transaction Server Explorer.(If you don't see it just log off and again log on).

step 3 :  You will see one window naming "Microsoft Management Console ....".

step 4 :  Expand "Microsoft Transaction Server".

step 5 :  Then expand "Computers".

step 6 :  Then expand "My Computer".

step 7 :  Then expand "Packages Installed".

Step 8 :  Then Right click on the "Packages Installed" and choose New->Package->Create an empty package and
          supply the name(for example -> MyServer) press Next,make sure "Interactive user - the current logged on
          user" is checked, press finish.Now you will have one entry MyServer under "Packages Installed".

step 9 :  Expand MyServer.

step 10 : Then Right click on "Components" and select New->Component->Install New Component(s)->Add Files and
          browse until you get the "Server.dll" file and press finish.
          Now you will see name "GBasedbt.Server" in the right side of this window.Now you have created the MTS
          Component.Now right click on "GBasedbt.Test" select Properties->Transaction and make sure 
          "Requires a transaction" is checked.

Step 11 :  Now you Right Click on to "My Computer" and say "Refresh All Components",again right click and see
           if the MS DTC service has started or not.If it says "Stop MS DTC" it means MS DTC service has already
           started(you can verify the same if the green signal displays in "My Computer" icon) else just click
           "start MS DTC" which will display the green signal in "My Computer" icon.

     Now as far as MTS setup is concerned you have done.

Step 12 : Now you need to create the DSN name "stores" pointing to "stores7" database and click on 
          "Apply and Test Connection" to make sure that DSN is connecting to the server.

step 13 : Now run the Client.exe 
	  Update the connection string with proper values for 
	  i) Provider, ii) Data Source, iii) User Id  and iv) Password
	  For ODBC, Provider=MSDASQL and Data Source=stores
	  For OLEDB, PROVIDER=IFXOLEDBC and Data Source=<database>@<server>


	  Push "Execute" to run the sql statement.It should show the following message :

              "Execute Complete.Change should have been commited".
 
          Review all the above steps if get any error messages
          You can also verify the same from executing the following SQL from the dbaccess :

              select ship_charge from orders where order_num=1006;

          "Client.exe" can be run as many as times to make sure its working fine and 
	  updates the ship_charge column.


TroubleShooting:

If installing the object on Win2000, you will find MTS under

-->START --> SETTINGS --> CONTROL PANEL --> Administrative Tools --> COMPONENT SERVICES
