DTCTest.exe - Testing Distrubuted Transactions
version: 1.0x003
last updated: 7 July 2004
platform: SQL Server 2000 running Windows XP and Windows Server 2003
Description:
DTCTest is a command line utility for testing distributed transactions with SQL Server over ODBC or OLEDB.
Usage:
DTCTest.exe version 1.0x3
DTCTest usage:
-T DTC Transaction Server (default = local)
-D transaction descript (default = NULL)
-t transaction timeout
-d data access API used [ODBC|OLEDB]
-S SQL Server name
-U SQL Server user name
-P SQL Server password
-E SQL Server trusted connection
-q SQL Server query to execute
-v version information
-? command line usage
Sample usage:
dtctest.exe -S (local)\sql80 -E -D "Hello DTC" -q "update pubs..sales set qty =
qty +1" -t 0 -d ODBC
Output:
Transaction ID {16A5D843-3863-4A74-BDA0-215980E042FC}
(C)ommit or (A)abort aInstallation:
Installation:
Simply copy DTCTest.exe onto your machine.
Download DTCTest.zip
Download DTCTest-src.zip (Visual Studio 2003 - C++ project)
Requirements:
Windows XP or Windows Server 2003.
Planned functionality enhancements:
None
***