|
Home > Archive > BizTalk Server General > November 2004 > SQL Adapter
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
| |
| Danny Buysse 2004-11-15, 2:46 am |
| Did you add the SQL schema with the 'Add Generated Items - Add Adapter' wizard.
If you do so, you'll have a step where you are being asked to fill in the
Target namespace and Request and Response root element name. It are these
values you need to reuse in your configuration.
Hope this helps.
"Dens" wrote:
> 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
>
|
|
|
|
|