WCF Adapter Quirkiness

by | Nov 10, 2010 | BizTalk Community Blogs via Syndication

If you are going to install the WFC adapters for SQL, SAP, and Oracle, there is not a way that the install can be complete during a silent install.

The adapters don’t show up in the management console without having to manually add them.

Until now

All you need to do is run this AddAdapter.vbs (BizTalk 2010)

AddAdapter "WCF-SQL", "WCF-SQL adapter", "{59b35d03-6a06-4734-a249-ef561254ecf7}" 



AddAdapter "WCF-SAP", "WCF-SAP adapter", "{a5f15999-8879-472d-8c62-3b5ea9406504}" 



AddAdapter "WCF-OracleDB", "WCF-OracleDB adapter", "{d7127586-e851-412e-8a8a-2428aeddc219}" 



AddAdapter "WCF-OracleEBS", "WCF-OracleEBS adapter", "{f452bb15-7a0d-495d-9395-c630d3fd29cd}" 





Sub AddAdapter(strAdapterName, strAdapterComment, strAdapterMgmtCLSID) 



Set objLocator = CreateObject("WbemScripting.SWbemLocator") 



Set objService = objLocator.ConnectServer(".", "root/MicrosoftBizTalkServer") 



Set objAdapterClass = objService.Get("MSBTS_AdapterSetting") 





On Error Resume Next 



Set objAdapterInstance = objService.Get("MSBTS_AdapterSetting.Name='" & strAdapterName & "'") 



If (objAdapterInstance is Nothing) Then 



On Error Goto 0 



Set objAdapterInstance = objAdapterClass.SpawnInstance_ 



Else 



On Error Goto 0 



End If 





objAdapterInstance.Name = strAdapterName 



objAdapterInstance.Comment = strAdapterComment 



objAdapterInstance.MgmtCLSID = strAdapterMgmtCLSID 





On Error Resume Next 



objAdapterInstance.Put_(0) 



If (Err.Number <> 0) Then 



Else 



End If 



End Sub


So this is what the batch file looks like:


"\\BizTalk Server 2010 Enterprise\WCF-LOB-Adapter-SDK-2010-x86\AdapterFramework.msi" /quiet MUOPTIN="Yes"



"\\BizTalk Server 2010 Enterprise\WCF-LOB-Adapter-SDK-2010-x64\AdapterFramework64.msi" /quiet MUOPTIN="Yes"



msiexec /i "\\BizTalk Server 2010 Enterprise\BizTalk Server\AdapterPack_x86\AdaptersSetup.msi" /qn ADDLOCAL=ALL



msiexec /i "\\BizTalk Server 2010 Enterprise\BizTalk Server\AdapterPack_x64\AdaptersSetup64.msi" /qn ADDLOCAL=ALL



cscript.exe "\\BizTalk Server 2010 Enterprise\BizTalk Server\AddAdapter.vbs"





And you get something that looks like this: