I'm trying to use the SQLNCLI 10 driver to set up a Linked Server to a legacy SQL Server 2000 instance on our network.
I understand you cannot use Version 11 as it doesn't support SQL Server 2000 (running on Windows 2003 latest service packs). The SQL Server 2012 is on Windows 2008 x64.
I can create the conenction, and the databases and their schemas display, but when I try to execute a query I get:
Msg 8522, Level 16, State 3, Line 1 Microsoft Distributed Transaction Coordinator (MS DTC) has stopped this transaction.
Anyone seen this or know how to resolve it?