BizTalk Server General - can not access remote DB via SQL adapter

Author

can not access remote DB via SQL adapter

Frank

2005-12-07, 3:49 am

Hi all,

I use the SQL adapter generate wizard,
first, the data base connection is ok
second, the port type is receive port and I use the select statement, that is
"select orderid from orders FOR XML AUTO, ELEMENTS"

but I got the erroe message ,that is

Failed to execute SQL statement, please ensure that the supplied syntax is
correct.
the partner transaction manager has disabled its support for remote network
transactions

When I use the local DB, eveything is fine but it always fails in the remote
DB
the remotre DB and local DB in the same domain
I use the dtctester to test, it can work, I think the DTC service is open

Pleae someone help me

Thank you

Frank