|
| Hello,
I'm currently working on a project using BizTalk Server 2004. The
application I'm developing create an xml document with som data that
have to be inserted in an SQL Database.
BizTalk should insert the datas in the Database and then send another
xml document with the id of the new item just created in the database.
I generated a SQLService Schema and designed an orchestration. In my
orchestration I have :
Receive shape- Construct shape - transform shape - send shape -
receive shape - construct - transform - send.
Everything work find until the second receive shape and datas are
inserted in the database. I'm working with stored procedure. I created
an new port with type Static Soloct-Response root, primary transport
SQL.
Everything stops here. My stored procedure give back a schema but
BizTalk is unable to understand it. The service is suspended...
unfortunately... The problem is I don't knowe wich value I have to
provide when I make the configuration of my SQl port. In the adapter
configuration, I write the connection String (no problem).. but then,
what should I write for the target document namespace and Response
Root element name?
I tried to write the namespace of my project and the namespace of my
schema but I get everytime an error...
Message error is: Microsoft.BizTalk.XLANGs.BTXEngine.BTXTimerMessage
Thanks for your help... it is the first time I work with bizTalk ....
Regards
Dens
|
|