Error while running Oracle WCF DB adapter from adapter pack V2 Beta with BTS2006R2 RRS feed

  • Question

  • I get this error in Event Viewer:
    The adapter failed to transmit message going to send port "SendPort_SelectAccTable" with URL "oracledb://". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.InvalidUriException: Both ServiceName and ServiceType should be specified
       at Microsoft.Adapters.OracleDB.OracleDBConnectionUri.set_Uri(Uri value)

    My tnsnames.ora contains:
    (I copied this string from the Oracle Enterprise Manager console)

    In BizTalk Server Admin Console > Application > Sample Application > Configure > Send Ports > SendPort_SelectAccTable > URI contained oracledb://adapdoc in Binding.xml, and after importing it, I modified it to oracledb:// .

    Could you please help?

    Thanks in advance.

    Friday, April 3, 2009 7:05 AM


  • Hi Advait,

    You need not specify hostname and port in URI when you specify tnsnames.ora entry in URI. Your URI should look like : oracledb://Walter.

    Friday, April 3, 2009 7:12 AM

All replies