I can't see the BizTalk plug-in for WCF Lob Adapter SDK or I can't see the Consume Adapter Service from Add generated items

Posted: March 4, 2011  |  Categories: BizTalk Uncategorized

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 trying to consume a stored procedure and create WCF-SQL schemas using the WCF-SQL adapter but on selecting “add Generated items” from the menu in visual studio they got a screen like this that was missing the Consume Adapter;My first thought was that they have not installed the WCF LOB Adapter SDK and The Microsoft BizTalk adapter for SQL server but when I checked both items had been installed. I suggested that they try reinstall both components but this did not solve the problem (see http://www.microsoft.com/downloads/en/details.aspx?FamilyID=CEB0BB34-F9D2-4D14-8BBE-0311D227B091#Instructions for how to install the WCF-SQL adapter).

I next got them to check all the pre-requisites for the two installed components. On checking the version of BizTalk in the registry they reported that they had version 3.5.1602.0. “Ah ha!” i said, “you are using BizTalk 2006, the WCF SQL adapter can’t be used with that version” (see http://biztalkmessages.vansplunteren.net/2010/03/04/biztalk-2006-r2-version-number-not-updated-after-applying-sp-1/ for BizTalk version numbers).  No they said I am using BizTalk 2006R2 because I can see that I have AS2 and the WCF-HTTP adapters. Those components only exist in BizTalk 2006R2 not BizTalk2006.

Now I was interested so I tried to reinstall the WCF LOB Adapter SDK myself. On reinstalling  the following screen came up and now I smelt a rat. The option to install the BizTalk plugin was missing. The only item that you could install was the run time components.

I opened the BizTalk administration console and right-clicked on to show that version  3.6.1404.0 of BizTalk was installed in direct contradiction to that reported in the registry. This is the correct version number for BizTalk2006R2.

As a longshot I decided to changed the version number in the registry to 3.6.1404.0. On reinstalling the WCF LOB Adapter SDK the option to the install the BizTalk plugin is now available and if you select it the consume adapter it is runnable in the “Add generated items” from the visual studio menu. How on earth the version number got set to the wrong version in the registry is beyond me but now the newbie was on his way.

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