none
Not found any in list- when Create New Adapter RRS feed

  • Question

  • I hv installed Oracle Client 11g R2  on my Windows Windows 2008 x64

    WCF LOB Adapter SDK SP2  and then Adapter Pack 2.0 - All successful

    When I try to add new Adapter it suppose to show the list of adapters in combo box , But its empty

    What could be issue ?

    Friday, July 23, 2010 3:32 PM

Answers

  • Yes, the adapter should only support 11.1.x client currently.

    "The Oracle Database adapter supports Oracle Data Access Components for Oracle Client 11.1.0.6 with Patch Set 11.1.0.7. The Oracle Database adapter supports Oracle Data Access Components for Oracle Client 11.1.0.6 with Patch Set 11.1.0.7. "


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, August 2, 2010 9:42 AM
    Moderator

All replies

  • You have to select WCF-Custom and then use Customize next to the drop down box.

    In the new dialog box select "bindings" tab - the adapter should show up in the drop down box there.


    If you like my post or consider it as a valid answer, please use the buttons to show me - Oliver

    http://biztalk.hauth.me

    Friday, July 23, 2010 4:15 PM
  • I am talking about firs time configuration

    after Install you normally Select Adapters and Right Click Add New Adapter and Enter OracleDBAdapter and select "WCF-Oracle" from the drow down box.

    Hope you got it now. There its showing Empty List.


    Raj

    Friday, July 23, 2010 4:22 PM
  • Have you installed both 32 and 64 bit adapter pack? 32 bit pack will be needed for design time experience, since VS and BizTalk mmc are 32 bit processes.
    Sunday, July 25, 2010 5:24 PM
  • My OS : windows 2008 x64

    VS also 64bit and BizTalk 64bit so what is the point of installing 32bit?

     

    Sunday, July 25, 2010 9:21 PM
  • Ah yes, I remember. You need to install both versions when running on a 64bit environment. It's a known bug that the 64bit version doesn't create the entries for the drop down boxes.

    This might due to the fact that mmc is still a 32bit process on a 64bit operating system or due to any other bug, not sure. But it helps to install the 32bit adapter pack afterwards.


    If you like my post or consider it as a valid answer, please use the buttons to show me - Oliver

    http://biztalk.hauth.me

    Monday, July 26, 2010 4:28 AM
  • These processes run in WOW mode and since they are running as 32 bit processes they will try to load the 32 bit adapter and not the 64 bit one.

    Monday, July 26, 2010 7:51 AM
  • Do I need to install both ?

    LOB & Adapter pack ? or only Adapter pack is enough?

    Monday, July 26, 2010 8:38 AM
  • You need to install:

    LOB SDK x64

    LOB Adapter Pack x64

    LOB Adapter Pack x86


    If you like my post or consider it as a valid answer, please use the buttons to show me - Oliver

    http://biztalk.hauth.me

    Monday, July 26, 2010 9:01 AM
  • LOB SDK x64

    http://www.microsoft.com/downloads/details.aspx?familyid=56278FDE-B708-469C-987E-DED9C6C5E580&displaylang=en

    when I try to install  LOB Adapter Pack x64 - its not installing, Its prompted me to repair / change/remove.

    what should I do? repair ?

    or can you send me the links to download and install the required things to make it work for Oracle adapter.

    Monday, July 26, 2010 9:15 AM
  • Then you've already installed it. You just need to install all 3 mentioned installation packages once. So I guess you already installed LOB SDK and Adapter Pack x64? Then you'll need only to install Adapter Pack x86.
    If you like my post or consider it as a valid answer, please use the buttons to show me - Oliver

    http://biztalk.hauth.me

    Monday, July 26, 2010 9:22 AM
  • I uninstalled everything and now instaling as you suggested

    1.Instaleld LOB SDK - Success

    2. Install LOB 64 - Success

    3. Install LOB 32 - failed  and I got the below error
    Another version of WCF LOB Adapter SDK already exists.
    Intallation cannot continue. Remove Existing WCF LOB Adapter SDK through Add/Remove
    programs and try install again!

    Monday, July 26, 2010 9:31 AM
  • LOB Adapter pack 32bit not the LOB Adapter SDK.

    x64 SDK + adapter pack

    x86 only adapter pack


    If you like my post or consider it as a valid answer, please use the buttons to show me - Oliver

    http://biztalk.hauth.me

    Monday, July 26, 2010 9:46 AM
  • Hi Oliver,

    I am very confused. I don not find the LOB Adapter pack, I could find only SDK.

    Do you mean BizTalk Adapter Pack ? If not, Can you send me the URL's to download !

    Monday, July 26, 2010 10:09 AM
  • Yes, the Adapter pack is the "LOB adapter pack" based on the SDK.

    LOB = Line of Business = Oracle, SAP, Siebel, etc.


    If you like my post or consider it as a valid answer, please use the buttons to show me - Oliver

    http://biztalk.hauth.me

    Monday, July 26, 2010 10:11 AM
  • Hi Oliver

    Thank for your help. Finally its working. The issue is

    when I try to install on LOB and Adapter pack it was pointing to C:\Program Files\ folder hence after install I was unable to find the "Consume Adapter Service" ( at add generated items).

    Now what I did was while install selected Custom insted of Tipical /complette and changed the path to C:\ProgramFiles(x64) folder

    Now everything fine. But I got below error while connecting to Oracle and I did not find the assembly in assembly folder.

    Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

    Monday, July 26, 2010 11:50 AM
  • Hi Oliver,

    I installed ODP.net and now I can find the 'Oracle.DataAccess' Version 2.112.1.0 on Assembly folder.

    but still i am getting same error

    Monday, July 26, 2010 12:38 PM
  • I'm not quite sure as I never used the Oracle adapter, but try to add it to your BizTalk application. Go to the admin console, to your application and use Add.. / Assemblies. Maybe it'll help?
    If you like my post or consider it as a valid answer, please use the buttons to show me - Oliver

    http://biztalk.hauth.me

    Monday, July 26, 2010 2:31 PM
  • I hv installed ODP.net 32 bit too so I got the  Oracle.DataAccess Version 2.111.xxx file loaded in Assembly folder.

    But When I try to connect Oracle I got the below error :

    Connecting to the LOB system has failed.
    ORA-12154: TNS:could not resolve the connect identifier specified.

    Monday, July 26, 2010 2:59 PM
  • TNS points to a Oracle specific problem as the tnsnames.ora contains all connection settings for Oracle Databases. So in my mind the BizTalk part has been set up correctly, now it's up to setting up the oracle connection correctly.
    If you like my post or consider it as a valid answer, please use the buttons to show me - Oliver

    http://biztalk.hauth.me

    Monday, July 26, 2010 3:31 PM
  • Hi,

    You are correct, I installed Oracle 11G R2, which has support of Windows 2008 64bit. Unfortunately it installed Oracle.DataAccess of version 2.112.xxx  which is not accepeted by BizTalk Adapter pack 2.0.

    BizTalk Adapter Pack accepts only 2.111.xxx Version  (11g R1 has this file ) which does not have support . So I kept my Development Box on SKY to wait for new version of BizTalk Adapter pack.

    no solution for this issue?

    Wednesday, July 28, 2010 1:58 PM
  • Yes, the adapter should only support 11.1.x client currently.

    "The Oracle Database adapter supports Oracle Data Access Components for Oracle Client 11.1.0.6 with Patch Set 11.1.0.7. The Oracle Database adapter supports Oracle Data Access Components for Oracle Client 11.1.0.6 with Patch Set 11.1.0.7. "


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, August 2, 2010 9:42 AM
    Moderator