Friday, June 10, 2011

Unable to get binding type for binding extension sqlBinding

Unable to get binding type for binding extension sqlBinding

While promoting code from one 64 bit environment to another, I can across the following error while changing the configuration

Unable to get binding type for binding extension "sqlBinding".
Verify the binding extension is registered in machine.config."

Since I have come across this a couple of times, I might as well put a reminder out for myself:
The SQL adapter is a WCF custom binding, which is registered under System.ServiceModel in the machine.config file. A 64-bit platform has two machine.config files, one used by the 32-bit applications and the other used by the 64-bit applications. So, when you install the 64-bit version of the BizTalk Adapter Pack, the setup wizard registers the bindings in the 64-bit version of the machine.config file. However, BizTalk Server Administration console runs as a 32-bit process and hence when you configure a port for the adapter, it checks for the bindings in the 32-bit version of the machine.config file and fails giving an error.
Install both the 32-bit and 64-bit versions of the BizTalk Adapter Pack on a 64-bit WCF LOB Adapter SDK installation.

More details:-
1. Install WCF LOB Adapter SDK 2010.. [AdapterFramework64.msi] (It prompts for 3.0.5005.0 & above) .... go for SDK 2010 if you are using BTS 2010.
2. Then goto BizTalk installation files... and install both 64 bit as well as 32 bit AdapterPacks... 

Thanks Eric

1 comment:

  1. Saved my own time... when I faced the same issue on other set of servers.


FEEDJIT Live Traffic Map