"Russell Kahler" <russell@oncontact.com> wrote in message
news:423b9596.0406291430.126d0856@posting.google.com...
> I have two server defined (S1 and S2) S1 has a link defined to S2. If
> I open Query Analyzer and run a query referencing S2 server. My
> statement returns data (lets say I am using MSSQL standard
> authenitcation). Now I have a ASP.NET application that connects to S1
> server using ODBC. The exact same statement returns an error.
>
> Driver][SQL Server]The operation could not be performed because the
> OLE DB provider 'SQLOLEDB' was unable to begin a distributed
> transaction.
> ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB
> provider returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]
> ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB
> error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a].
>
> Russ....