-
Hi All, I use "Poll While Data Found" = True in an SQL Receive Location. But regardless number of records waiting in SQL Server for pickup, the receive location polls at pooling interval only. I've tried set the property to False/True - no difference. Have anyone had any issues with "Pool...
-
Hi everyone, got a real thorn in my side at the moment and am after some help.... Am currently on a project where we are using the xml capabilities of sql 2005 to store entire messages in a single xml column within a table in our database rather than push the data into normalized tables. The messages...
-
Hey Folks, Have a BizTalk solution deployed at a customer site and once every four weeks (or so), BizTalk generates the following event: "The adapter "SQL" raised an error message. Details "A connection with the transaction manager was lost. (Exception HRESULT: 0x8004D01C)"....
Posted to
BizTalk 2006
(Forum)
by
Anonymous
on
Mon, Oct 20 2008
Filed under: sql adapter, SQL SERVER 2005, SQL adapter error transaction error, BizTalk 2006 version
-
I have a series of Stored Procedures in a database that I am calling via the SQL Adapter. If/When I pass in my parms in certain scenarios, I'm seeing slightly different results that I'd like. Here are some examples: NULLs When I execute a map from a source xml to the destination xml that is passed...
-
Hi, I have a question regarding the SQL adapter and if it's possible to save an entire message in 1 column in a SQL table. I've tried using updategrams as well as stored procedures but am unable to map the entire message into one field in my target table. My stored procedure has 4 parameters...
-
1) Open the Solution Explorer 2) Save a copy of the current Schema just in case a. Right Click the Schema that you want to change b. Select “Open With …” c. In the “Open With…” dialog , select “Xml editor” and click Ok. d. Select all the text from the...
Posted to
BizTalk 2006
(Forum)
by
jedi_aka
on
Wed, May 28 2008
Filed under: sql adapter, database, BizTalk 2006 Editions, BizTalk, SQL Server
-
I am not exactly sure that I follow you...but I will try. When you use the SQL Adapter, you are not using web services, but rather a native BizTalk Adapter that uses MSDTC to support transactions. So what you can do is expose your orchestration as a web service which would allow your web applicaton to...
-
I am attempting to create a solution that will move data between an AS/400 DB2 database and a SQL 2005. I have installed and am successfully using the Host Integration server to receive data from the DB2. I can send this to a FILE successfully as well. I can't send this to a SQL stored procedure...
-
It's been a while since I commented on this original post, but I'll try to respond. If you suspect the cause to be a datatype issue, the first thing(s) to try is to elliminate that as an issue. The “Black Box” solution is to find a working table. In other words, build a dummy/test table with...
-
I would appreciate any insight you care to give here... I currently have a schema developed that retrieves data from my SetupRequest table (SQL Server 2005). I am selecting the records based on the value of my "Status" column (such as ... WHERE Status = 10 ) I may get back zero or dozens of...