RE: SQL Adapter

From: Danny Buysse (DannyBuysse_at_discussions.microsoft.com)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 01:21:01 -0800

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
>

Relevant Pages

  • Split messages
    ... This is based off the northwind database. ... Create document schema: ... Select the SQL entry, make sure that we are pointing to the SQL ... For the item select a receive pipeline and name it EmpSplitPipe.btp. ...
    (microsoft.public.biztalk.general)
  • Re: New to C# - DB question
    ... Firstly, you are interested in the System.Data namespace, also known as ... In there you will find a few sub namespaces for specific database ... is your sql statement. ... The former allows you to just execute some SQL, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Decouple SQL queries from class in OOP design
    ... If the data is owned by the application, embedding SQL might be ... - It couples the application to the database schema. ... - The "validate employee ID" functionality is likely to be used ...
    (comp.object)
  • Re: exporting into a SQL Server schema
    ... inside of the schema. ... The thing that's most confusing is that the dbo schema isn't ... take a look at the way the objects in the AdventureWorks database are ... It turns out that I'm moving some tables to a web hosted solution with sql ...
    (microsoft.public.access.externaldata)
  • RE: from XML to SqlCE
    ... you can load the XML into a data set and then into SQL CE. ... as there is no way for the dataset to create the database schema on the fly. ...
    (microsoft.public.sqlserver.ce)