Cannot work further with the step

Question

Hi,
I get this

No valid adapters installed on the machine.

Why?

---

Many Thanks & Best Regards, Hua Min

Answer 1

Install BizTalk LOB SDK and BizTalk adapter pack

Answer 2

Why don't I have such problem while following other tutorials? Why do I get the current issue while following this

http://blogs.msdn.com/b/biztalkmusings/archive/2009/10/05/a-simple-biztalk-server-2009-wcf-sqlserver-adapter-example.aspx

in Step 2?

---

Many Thanks & Best Regards, Hua Min

Answer 3

Any advice to this?

---

Many Thanks & Best Regards, Hua Min

Answer 4

Which adaptor service you want to consume . some times we need to make entry to machine config for 64 bit .

Answer 5

I was to do the above steps mentioned above for adding "ConsumeAdapterService".

---

Many Thanks & Best Regards, Hua Min

Answer 6

Any advice to this?

---

Many Thanks & Best Regards, Hua Min

Answer 7

Which adapterservice you want to consume . have you installed any out of box adapter like Oracle .please specify.

check machine config also.

Answer 8

I did not set up anything for Oracle. I followed the above steps only.

---

Many Thanks & Best Regards, Hua Min

Answer 9

you might have below scenario

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, Visual Studio runs as a 32-bit process and hence when you launch the Consume Adapter Service Add-in from Visual Studio, the plug-in checks for the bindings in the 32-bit version of the machine.config file and fails giving an error.

Refer below

http://msdn.microsoft.com/en-us/library/dd787990%28v=bts.10%29.aspx

---

If this post answers your question, please mark it as such. If this post is helpful, click 'Vote as helpful'.

Answer 10

Many thanks. When following this step in the link,
3. To register the SQL adapter binding:

    Search for the element "system.serviceModel" and add the following under it:

    <client>
      <endpoint binding="sqlBinding" contract="IMetadataExchange" name="mssql" />
    </client>

I don't know where I should add the above part as I can see these items for "system.serviceModel".

        <sectionGroup name="system.serviceModel" type="System.ServiceModel.Configuration.ServiceModelSectionGroup, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
            <section name="behaviors" type="System.ServiceModel.Configuration.BehaviorsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
            <section name="bindings" type="System.ServiceModel.Configuration.BindingsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
            <section name="client" type="System.ServiceModel.Configuration.ClientSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
            ...

---

Many Thanks & Best Regards, Hua Min

Answer 11

Below to that in machine.config file you will have another section with <system.serviceModel>
as below :

<system.serviceModel>
        <extensions>
            .....
        </extensions>
        <client>
            <metadata>
                <policyImporters>
                    <extension type="System.ServiceModel.Channels.ContextBindingElementImporter, System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL"/>
                </policyImporters>
                <wsdlImporters>
                    <extension type="System.ServiceModel.Channels.ContextBindingElementImporter, System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL"/>
                </wsdlImporters>
            </metadata>
        </client>
        <tracking>
            .....
        </tracking>
        <commonBehaviors>
            ....
        </commonBehaviors>
</system.serviceModel>

---

If this post answers your question, please mark it as such. If this post is helpful, click 'Vote as helpful'.

Answer 12

But I see these are already existing in the machine.config file
        ...
        <client>
            <metadata>
                <policyImporters>
                    <extension type="System.ServiceModel.Channels.ContextBindingElementImporter, system.workflowservices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL"/>
                </policyImporters>
                <wsdlImporters>
                    <extension type="System.ServiceModel.Channels.ContextBindingElementImporter, system.workflowservices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL"/>
                </wsdlImporters>
            </metadata>
        </client>
        ...

---

Many Thanks & Best Regards, Hua Min

Answer 13

behaviorExtensions-->

 <add name="sqlAdapterInboundTransactionBehavior" type="Microsoft.Adapters.Sql.SqlAdapterInboundTransactionBehavior, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

bindingElementExtensions-->

 <add name="sqlAdapter" type="Microsoft.Adapters.Sql.SqlAdapterBindingElementExtensionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

bindingExtensions-->

 <add name="sqlBinding" type="Microsoft.Adapters.Sql.SqlAdapterBindingCollectionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

add these configuration in required machine config(if Machine is 64 bit then add in both machine config)

If this post answers your question, please mark it as such. If this post is helpful, click 'Vote as helpful'.

Answer 14

behaviorExtensions-->

 <add name="sqlAdapterInboundTransactionBehavior" type="Microsoft.Adapters.Sql.SqlAdapterInboundTransactionBehavior, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

bindingElementExtensions-->

 <add name="sqlAdapter" type="Microsoft.Adapters.Sql.SqlAdapterBindingElementExtensionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

bindingExtensions-->

 <add name="sqlBinding" type="Microsoft.Adapters.Sql.SqlAdapterBindingCollectionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

add these configuration in required machine config(if Machine is 64 bit then add in both machine config)

If this post answers your question, please mark it as such. If this post is helpful, click 'Vote as helpful'.

Do you mean to add these two?
 <add name="sqlAdapter" type="Microsoft.Adapters.Sql.SqlAdapterBindingElementExtensionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

 <add name="sqlBinding" type="Microsoft.Adapters.Sql.SqlAdapterBindingCollectionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
where should I add both?

---

Many Thanks & Best Regards, Hua Min

Answer 15

Try with these two , if its run then it is ok .

 same problem i have faced . i have added these 3 config in 4 machine config(64 , 32 with version 4.0 and 2....)

If this post answers your question, please mark it as such. If this post is helpful, click 'Vote as helpful'.

added in machine config

Answer 16

Try with these two , if its run then it is ok .

 same problem i have faced . i have added these 3 config in 4 machine config(64 , 32 with version 4.0 and 2....)

If this post answers your question, please mark it as such. If this post is helpful, click 'Vote as helpful'.

added in machine config

Where to add both items?

---

Many Thanks & Best Regards, Hua Min

Answer 17

<system.serviceModel>--><extensions>

behaviorExtensions-->

 <add name="sqlAdapterInboundTransactionBehavior" type="Microsoft.Adapters.Sql.SqlAdapterInboundTransactionBehavior, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

bindingElementExtensions-->

 <add name="sqlAdapter" type="Microsoft.Adapters.Sql.SqlAdapterBindingElementExtensionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

bindingExtensions-->

 <add name="sqlBinding" type="Microsoft.Adapters.Sql.SqlAdapterBindingCollectionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

Answer 18

<system.serviceModel>--><extensions>

behaviorExtensions-->

 <add name="sqlAdapterInboundTransactionBehavior" type="Microsoft.Adapters.Sql.SqlAdapterInboundTransactionBehavior, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

bindingElementExtensions-->

 <add name="sqlAdapter" type="Microsoft.Adapters.Sql.SqlAdapterBindingElementExtensionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

bindingExtensions-->

 <add name="sqlBinding" type="Microsoft.Adapters.Sql.SqlAdapterBindingCollectionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

Hi,
After I've added these 3 items into machine.config, I did get these

There was an error loading your machine.config. Please correct the error and retry the operation.
An error occurred creating the configuration section handler for system.serviceModel/bindings: Could not load file or assembly 'Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Microsoft.ServiceModel.Channels.Tools.MetadataSearchBrowse.MachineConfigException: There was an error loading your machine.config. Please correct the error and retry the operation.
An error occurred creating the configuration section handler for system.serviceModel/bindings: Could not load file or assembly 'Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
   at Microsoft.ServiceModel.Channels.Tools.MetadataSearchBrowse.MetadataPanel.EnumerateAllAvailableBindings(String bindingExtensionName, String bindingConfiguration)
   at Microsoft.ServiceModel.Channels.Tools.MetadataSearchBrowse.MetadataPanel..ctor(MetadataUserControl usercontrol, AdapterProperties properties, String bindingExtensionName, String bindingConfiguration, String uri)

---

Many Thanks & Best Regards, Hua Min

Answer 19

Which Adapter Pack you have installed .

have you created instance of  adapter in Adapter part in Biztalk MMC .

read this Thread .HERE

Answer 20

I can't locate to the page by your link.

---

Many Thanks & Best Regards, Hua Min

Answer 21

sorry

click Here

Answer 22

Many thanks. I am following this

http://msdn.microsoft.com/en-us/library/dd788552%28BTS.10%29.aspx
to add Adapter to my BT 2009

But I see no Adapter to be selected below. Why?

---

Many Thanks & Best Regards, Hua Min

Answer 23

You need to install BizTalk Server Adapter Pack  in order to see something in list

WCF-SQL Adapter is also part of BizTalk Server Adapter Pack

---

If this post answers your question, please mark it as such. If this post is helpful, click 'Vote as helpful'.

Answer 24

Thanks. Is there a link for setting up that?


Does the above mean my Adapter pack setup is incomplete or not?

---

Many Thanks & Best Regards, Hua Min

Answer 25

Install LOB Adapter Pack Here

then install Biztalk Adapter pack "en_biztalk_adapter_pack_2.0_x86_x64_cd_339765"

yes ,if dropdown is not showing any adapter , Adapter pack is incomplete

Answer 26

Many thanks. But that is for BT 2010 in Win 08 server. But for me, I need the one for BT2009 in Win 03 server instead.

---

Many Thanks & Best Regards, Hua Min

Answer 27

in Biztalk Setup you will get both LOB + adapter Pack

Answer 28

No, the one above is not for Biztalk 2009.

---

Many Thanks & Best Regards, Hua Min

Answer 29

Any help to this as the current pack is for VS 2010 while I'm using VS 2008?

---

Many Thanks & Best Regards, Hua Min

Answer 30

Hi,

Actually, the WCF LOB Adapter for server 2003 and vs 2008 is available in the below link:

WCF LOB Adapter SDK SP2
http://www.microsoft.com/en-us/download/details.aspx?id=23015

Please let me know if this help solve your issue.

Thanks.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 31

Thanks. I took the download while I did take "WCF LOB Adapter SDK SP2 x86.exe" but I've checked that inside Installation Guide, it is talking about VS2010 and BT server 2010. Please see this
http://dl.dropbox.com/u/40211031/InstallationGuide.rar

---

Many Thanks & Best Regards, Hua Min

Answer 32

I've downloaded the file(x64 version). The installation guide is exactly for version 2009, not sure why you get a copy for version 2010. Anyway, you can get the installation guide via the following link:

WCF LOB Adapter SDK SP2 Documentation
http://www.microsoft.com/en-us/download/details.aspx?id=4490

Hope this helps, thanks.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 33

As I have Win 03 server, this is why I did take x86 version yesterday. Here I've tried why you suggest, but I've got this

when I run "AdapterFramework64.msi".

---

Many Thanks & Best Regards, Hua Min

Answer 34

You are correct :) For 32-bit os, you should run the x86 version installation package. However, both x86 and x64 share the same installation guide. Did you run into any issue if you try installing the x86 version with following the installation guide?

Thanks.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 35

Thanks. I have finished the setup for x86 on my Win 03 server. But why do I still see no options below, after I've shut down the server and have restarted it after the setup


within
BT server 2009 admin console > BT server 2009 Admin > BT grop > Platform settings > Adapters > Right-click it then New, to get the above

---

Many Thanks & Best Regards, Hua Min

Answer 36

My bad. I should have mentioned that you will also need to install the adapter pack. You may follow the installation guide below:

Microsoft BizTalk Adapter Pack 2.0 Installation Guide
http://www.microsoft.com/en-us/download/details.aspx?id=18352

Thanks.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 37

Sorry, inside that, it does further lead me to this
http://www.microsoft.com/en-us/download/details.aspx?id=23015

but I've done the relevant setup for it. Can you please advise what is missing for that I see empty list within Adapters?

---

Many Thanks & Best Regards, Hua Min

Answer 38

Hi Hua Min,

This is one of the pre-requisities of the installation. Since you've already installed the sdk, you may skip this step and go through the guide.

Feel free to let me know if you encounter further troubles :)

Thanks.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 39

A quick note that you may skip to Installing the BizTalk Adapter Pack part if all the pre-requisities are installed.

Thanks.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 40

Sorry, are you sure the empty list is due to missing Adapter pack? How about that I can see some Adapter items below?

---

Many Thanks & Best Regards, Hua Min

Answer 41

The empty means all the available adapters has already been in the list. What adapter you need to add? If it was WCF-SQL adapter, based on my experience, it should be available after you installing the adapter pack.

Thanks.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 42

Thanks. And for this, we have to proceed with the setup disk of the Adapter pack, right?

---

Many Thanks & Best Regards, Hua Min

Answer 43

Thanks. And for this, we have to proceed with the setup disk of the Adapter pack, right?

---

Many Thanks & Best Regards, Hua Min

You are correct. The steps are elaborated in the installation guide, here's the direct quote:

To install the BizTalk Adapter Pack in interactive mode

• Insert the Microsoft BizTalk Adapter Pack installation disk into the CD-ROM drive.

• From the root location of the installation CD, double-click AdaptersSetup.msi (for an x86-based platform) or AdaptersSetup64.msi (for an x64-based platform).

  Note

  If you are installing the BizTalk Adapter Pack on a virtual machine, the setup wizard might not proceed beyond a dialog box informing that the setup is checking for available disk space. In such cases, we recommend that you use the silent installation option. For more information, see Installing the BizTalk Adapter Pack in Silent Mode.

• Read the information on the Welcome screen, and then click Next.

• Read and accept the end-user license agreement (EULA), and then click Next.

• In the Choose Setup Type dialog box:

  • To install the most common features, click Typical.
  • To select the adapters you want to install, click Custom, and then proceed to the next step.
  • To install all the features, click Complete.

    Important

    To install only the adapter that you will use to interface with your enterprise application, you should perform a Custom installation.

    Note

    For this release, Typical and Complete options essentially perform the same action.

• Perform this step if you chose to do a Custom installation in the previous step. If you chose to perform a Typical or Complete installation, skip this step and proceed to the next step.

  1. In the Custom Setup dialog box, expand the Base Adapters node to see the list adapters available with the BizTalk Adapter Pack.
  2. For the adapters that you do not want to install, click the icon next to the adapter name, and then select Entire feature will be unavailable.
  3. Similarly, expand the ADO Providers node, and then select the providers that you do not want to install.
  4. Click Next.

• Click Install.

• In the Customer Experience Improvement Program dialog box, specify whether you would like to enroll for the Customer Experience Improvement Program (CEIP). As part of CEIP for BizTalk Adapter Pack, you will share the following data with Microsoft:

  • Data related to the computer hardware on which you are installing the BizTalk Adapter Pack.
  • Data related to the enterprise application versions you will be using with the BizTalk Adapter Pack.

  Specify your choice and click OK. For more information about CEIP, see http://go.microsoft.com/fwlink/?LinkID=144699.

  Note

  You can always change your preference regarding enrolling for CEIP by running the Setup in Repair mode from the Control Panel.

• Click Finish.

Let me know if you encounter any further trouble, thanks.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework