Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
> 
WCF-SQL Adapter not displayed in list

Answered WCF-SQL Adapter not displayed in list

  • Tuesday, February 21, 2012 6:48 PM
     
     
    Sign In to Vote
    0

    Environment:

      Windows 2008 R2

      BizTalk 2010

      WCF LOB Adapter SDK 3.0.6527.0

      BizTalk Adapter Pack(x64)

    After installing the LOB Runtime and BTS Addin + the Adapter Pack (SQL Server adapter only), I find that the machine.config files updated properly, but the WCF-SQL adapter itself is not present in the list of BTS adapters.  Nor can I add the adapter since it is not available in the drop down menu when I try to add an adapter.

    I have tried a repair of the adapter pack and a repair on BTS 2010.  Neither made any difference.

    Any suggestions?

     

     

All Replies

  • Tuesday, February 21, 2012 6:50 PM
     
     
    Sign In to Vote
    0

    go to this thread..its similar thread http://social.msdn.microsoft.com/Forums/en-AU/biztalkr2adapters/thread/023d4a44-f6eb-49eb-b511-758de5603dae 

    also wcf-sql adapter doesnot come when you install adapter pack 2......you need to create a adapter using add adapter proces....you can use this post for that http://soa-thoughts.blogspot.com/2010/08/wcf-sql-adapter-table-operations.html

    • Edited by sriaug Tuesday, February 21, 2012 6:52 PM
    •  
     
  • Tuesday, February 21, 2012 7:04 PM
     
     
    Sign In to Vote
    0
    Thanks for the info.  I had already checked out the first link in your post.  Doesn't seem to apply.  In the second link (kinda follows the first, somewhat), I have tried manually adding the adapter to the BTS adapter list.  Can't do it because in step 3 the WCF-SQL adapter entry is not being displayed in the Adapter drop down list.
     
  • Tuesday, February 21, 2012 7:17 PM
     
     
    Sign In to Vote
    0
    did you install these 3 things

    64-bit WCF LOB Adapter SDK SP2

    64-bit BizTalk Adapter Pack.

    32-bit BizTalk Adapter Pack.


    • Edited by sriaug Tuesday, February 21, 2012 7:19 PM
    • Proposed As Answer by sriaug Wednesday, February 22, 2012 4:38 PM
    • Unproposed As Answer by sriaug Thursday, March 01, 2012 6:48 PM
    •  
     
  • Tuesday, February 21, 2012 7:30 PM
     
     
    Sign In to Vote
    0

    No, yes and no. 

    The 64-bit WCF LOB Adapter SDK SP2 has been superseded by the WCF LOB Adpater SDK 2010 for BTS 2010.

    I installed the adapter pack from the DVD.  I can see it on my C: drive in the Microsoft BizTalk Adapter Pack(x64) folder.

    Why would I need to install the 32-bit version?

     
  • Tuesday, February 21, 2012 7:32 PM
     
     Answered
    Sign In to Vote
    0
    yes you need to install even 32-bit BizTalk Adapter Pack to get wcf adapter....
     just install even 32-bit BizTalk Adapter Pack then try it...
     
  • Tuesday, February 21, 2012 10:39 PM
     
     
    Sign In to Vote
    0

    Okay.  I installed the 32-bit adapter pack (SQL only) and was able to add the new WCF-SQL adapter.  The WCF-SQL adapter became available in the drop down list.

    Why is it not available when the 64-bit adapter is installed?  Is it because the BTS admin console is a 32-bit application???

    http://social.msdn.microsoft.com/Forums/en-US/biztalkr2adapters/thread/e8ec0643-2169-4b3d-b1f1-1bb0de955aff