MS DTC ODBC Sample

Transact-SQL Samples

Samples

MS DTC ODBC Sample

This program demonstrates how to use MS DTC in C++ using ODBC. It uses MS DTC to perform simultaneous updates on two SQL servers. The transaction in this example is client initiated. The client also initiates the commit operation.

Because this sample uses the ODBC interface, you'll need to configure ODBC data source names for two instances of SQL server to run this sample. Each data source name (DSN) must reference the pubs database in a separate instance of SQL Server. The authors table in the pubs database is used in this sample.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Msdtc\Odbc

Running the Sample

Open odbc.dsw in Microsoft® Visual C++® 6.0 and compile this program. Make sure to do the following before compiling:

  1. From the Tools menu, choose Options, and then click the Directories tab.

  2. From the Show directories for box, choose Include files and Library files, and ensure that these directories (as appropriate) are included and appear at the top of the list:
    • Include files: C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Include

    • Library files: C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Lib

To run the sample, open a Command Prompt window, and then change the current directory to where sqlcurs.exe is located. Run the program by entering "odbc -h".

See Also

MS DTC Samples