BizTalk Server - Passing SQL to SQL Server from BizTalk

Author

Passing SQL to SQL Server from BizTalk

G. Tarazi

2004-04-15, 6:41 pm

Hi

I need some clarification about that.

Can I pass SQL statements to SQL Server from a BizTalk orchestration? I am having currently a lot of problems with the updatagrams "I am not able to get them working at all" so maybe if I pass an SQL statement to the adapter, and get the results may fix me some of the problems.

Is that possible.

Otherwise I must start writing a webservice that will act as a DB Interface between BizTalk and the SQL Server (and I don't want to do that)

G. Tarazi

2004-04-15, 7:44 pm

I just exposed SQL Server as a web server using the XML SQL, I hope this will solve all of my problems.

"G. Tarazi" <Tarazi@LiveTechnologies.ca> wrote in message news:%23Srv%23SzIEHA.3968@TK2MSFTNGP12.phx.gbl...
Hi

I need some clarification about that.

Can I pass SQL statements to SQL Server from a BizTalk orchestration? I am having currently a lot of problems with the updatagrams "I am not able to get them working at all" so maybe if I pass an SQL statement to the adapter, and get the results may fix me some of the problems.

Is that possible.

Otherwise I must start writing a webservice that will act as a DB Interface between BizTalk and the SQL Server (and I don't want to do that)