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:
- From the Tools menu, choose Options, and then click the Directories tab.
- 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
- Include files: C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Include
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".