Unanswered: Using SQLNCLI with SQL2005 and SQL2000
Is it true that I cannot start a distributed transaction between a SQL Server 2005 instance (which starts the transaction) with an SQL Server 2000 instance with the SQL Native Client?
That is, I have made a .NET 2 application that calls an stored procedure on a local server within a transaction, and in turn that server is supposed to update rows on a remote server. The aplication uses the sqlclient component.
If it is not possible to use the SQL Native Client for a distributed transaction on a mixed server scenario as this, is there a workaround?