Geeks With Blogs

Bill Osuch - Random geek notes

After upgrading to a new 64-bit OS on our BizTalk server, I was unable to get the WCF-SQL adapter working - kept getting the "No valid adapters are installed on this machine" error message. The Admin Console had SOME of the WCF adapters visible, just not WCF-SQL. I found out that this was due to the fact that I had simply installed the 64-bit version of the Adapter Pack - both Visual Studio and the BizTalk Admin Console run as 32-bit processes, so you'll need to install that version as well.

So, to get ALL of your adapters working on a 64-bit machine, install the Adapter Pack products in the following order:

  1. 64-bit WCF LOB Adapter SDK SP2
  2. 64-bit BizTalk Adapter Pack.
  3. 32-bit BizTalk Adapter Pack.
Posted on Monday, October 18, 2010 9:34 AM BizTalk | Back to top


Comments on this post: BizTalk error - "No valid adapters are installed on this machine"

# re: BizTalk error - "No valid adapters are installed on this machine"
Requesting Gravatar...
Thank you for the information - this was exactly what I needed.

Also, all of the adapter packs can be found here: http://www.microsoft.com/biztalk/en/us/adapter-pack.aspx
Left by mtraskos on Nov 23, 2010 3:21 PM

# re: BizTalk error - "No valid adapters are installed on this machine"
Requesting Gravatar...
I am using 32 bit version of Windows 7. I am running BizTalk 2010 developer edition. I have installed adapter SDK 32 bit, then LOB adapters pack, and then registered these adapters through BizTalk admin console. Restarted all services including SQL.

When I do "add generated items" through visual studio, I am still getting the "No valid adapters installed on the machine." error. Any idea? Thanks.
Left by Digambar Kandangire on Apr 02, 2011 11:36 PM

# re: BizTalk error - "No valid adapters are installed on this machine"
Requesting Gravatar...
I am using 64 bit Win 7 with BT 2010 and I got this error and tried the above solution and million others.

The final thing that worked was hacking my /v4.0.... machine.config files (both for 32 bit and for 64 bit). When I installed, the /v2.0 machin configs get (at least) three new elements: sqlAdapterInboundTransactionBehavior, sqlAdapter and sqlBinding. When I put these same elements in the /v4.0 machine configs and rebooted this error went away and I can do add WCF SQL without problems! (so far)
Left by Jim on Sep 09, 2011 11:04 AM

# re: BizTalk error - "No valid adapters are installed on this machine"
Requesting Gravatar...
Hi Jim,

I have the same problem.I followed the steps:
1.64-bit WCF LOB Adapter SDK SP2
2.64-bit BizTalk Adapter Pack.
3.32-bit BizTalk Adapter Pack.

It doesn't work for me. How do you hack you machine to make it work? I'm not that techy. Can you give some detail steps?

Thanks,
Cindy
Left by cindy liu on Jan 25, 2012 10:19 PM

# re: BizTalk error - "No valid adapters are installed on this machine"
Requesting Gravatar...
Even though you add the adapters, you cannot consume an adapter service via visual studio 2010 until you modify your machine.config. This is a great how-to article that resolved my issue :
http://freelance-wizardry.blogspot.com/2010/04/adding-add-adapter-service-reference.html
Left by AineEithne on Oct 01, 2012 2:18 PM

Your comment:
 (will show your gravatar)


Copyright © Bill Osuch | Powered by: GeeksWithBlogs.net | Join free