Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Biztalk
|
Biztalk General discussion about Biztalk server.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Biztalk section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 28th, 2003, 06:36 AM
Authorized User
 
Join Date: Aug 2003
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Updating database using Adapter for SQL Server

using biztalk Adapter for SQL Server is it possible to update or insert a record in database based on condition
suppose i have flag in xml incoming document o or 1
based on the flag i want to update the two different tables
how can i do this , is it possible do to while mapping the documents or i have to some thing else.

help me very urgent.

thanks in advance


syedjavid
__________________
syedjavid
 
Old October 30th, 2003, 05:37 AM
Registered User
 
Join Date: Oct 2003
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello,

It is possible with XLANG orchestration.
Receive the document, make a decision with a specific field, start/or not a channel for update the db.

On my side I get an error with the aicsql_sample provided in the Learnbiztalk :
My channel accept only an INSERT statement with 'block' and 'after' or a stored procedure with 'sproc'. and only one operation for a single file.

the delete/update statement with 'block' & 'before'
or sproc and block in the same file doesn't work and generate an error 0x80004005 unable to analyse the document

Any idea?

Eric.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating SQL Database using Windows Forms in VB planopeeks VB Databases Basics 5 June 12th, 2008 11:33 AM
Query: Biztalk Server 2004 - SQL Adapter simplyvivek Biztalk 1 March 23rd, 2006 06:36 AM
Updating to a SQL Database Arsi C# 3 August 23rd, 2004 12:49 PM
Updating to SQL Database Arsi Classic ASP Databases 4 August 23rd, 2004 12:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.