Sep 292009

According to the DTCTest tool documentation, you create a DSN, and run the DTCTester.exe

When I ran it, I got the following error:

SQLSTATE=IM002,Native error=0,msg='[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified’

The tool is 32 bit, and access the ODBC for the 32 bit client, not the 64 bit client that is in the Administration Console. To access the 32 bit client, you have to open up: c:\windows\syswow64\odbcad32.exe