May 28

Creating BizTalk WCF-SQL Adapter schemas

Make sure you create WCF-SQL adapters against the target database Do not use stubs A stub generates metadata that may be different The Microsoft BizTalk

By Mark Brimble
Feature blog image

Aug 19

Can I use a BizTalk WCF-SQL send adapter with a SQL 2012 Always on Database?

I think the answer is no unless you are prepared to accept the risk of duplicates and/or lost messages Let me explain why below This is a summary of

By Mark Brimble
Feature blog image

Apr 18

WCF SQL adapter error: System.Data.SqlClient.SqlException: Maximum stored procedure, function, tr...

Last week I started to get this error in one of the solutions that I had developed The solution had been working fine and all of a sudden in UAT this error

By Mark Brimble
Feature blog image

Apr 12

Query notification and the BizTalk WCF SQL Adapter: Comments and unresolved questions

I work with a architect who has an obsession about not allowing BizTalk to poll SQL servers We have tried many times to cure their disorder One of the

By Mark Brimble
Feature blog image

Apr 6

WCF SQL Adapter times-out with Composite Operation

Recently one of my colleagues came to me with this problem and I pointed him in the direction of Thiago’s article on the WCF SQL adapter A little while later

By Mark Brimble
Feature blog image

Mar 22

Should the WCF-SQL adapter be used in low latency scenarios?

I recently outlined a low latency solution using BizTalk 2010 where the response had to return in less than 1 second 99% of the time The solution was tested

By Mark Brimble
Feature blog image

Mar 4

I can't see the BizTalk plug-in for WCF Lob Adapter SDK or I can't see the Consume Adap...

I was trying to help a newbie developer with the WCF adapter today and got stumped for awhile by the above problem They were using BizTalk 2006R2 and were

By Mark Brimble
Feature blog image

Dec 23

Mapping an XML data type from a SQL stored procedure to a BizTalk schema

If you use the the WCF adapter wizard to generate the schema from the stored procedure then the XML data type is now of string type in the result set schema

By Mark Brimble
Feature blog image

May 5

The SQL Adapter and Apostrophes

I got an amusing call from a DBA the other day saying that the BizTalk SQL adapter was failing whenever he sent through a message that had an apostrophe in

By Mark Brimble
turbo360

Back to Top