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 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 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
BizTalk360
BizTalk Server

Over 500+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Manage and monitor serverless
components effortlessly

Learn More
Atomicscope
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top