BizTalk Server Orchestration - SQL Adapter Error

Author

SQL Adapter Error

2004-09-22, 9:56 pm

Hi All,
I have a small problem.
My host machine have
a>Windows 2003 server machine
b> Biztalk Server 2004
c> SQL Server

Remote Server
a>Windows 2000 Server
b>SQL Server

I am trying to generate Schema using SQL Adpter in receive location in my
host machine.SQL Adapter connect to Remote Server for generating schema.I can
able to connect to remote server but as soon as i provide stored procedure
name and click next i am receiving following error.

Failed to connect SQL Statement.Please ensures that the supplied syntax been
correct.The Transaction has already been implcitly or explicitly committed or
aborted.
my storedprocedure look like this
select * from orders for xml auto,xmldata

Thanks
sg