DTCTester – Data source name not found on 64bit

December 16th, 2008

The DTCTester app tests communication to SQL Server via DTC, using ODBC to find your server.  64 bit Windows keeps the DSN’s in two different location – a 64 bit ODBC DSN list, and a different 32 bit list.  So, if you create the DSN in the 64 bit hive, the DTCTester program won’t find it.

To fix, make sure you create the DSN in the 32-bit hive by running %systemroot%\SysWow64\odbcad32.exe.

Posting this for the next time I forget (who uses ODBC anymore anyway!?)…

Tony Rasa Esoterica

  1. January 9th, 2009 at 19:29 | #1

    Can I have more details on this?

Comments are closed.