none
oracleDBBinding vs oracleEBSBinding RRS feed

  • Question

  • Hello,

    I am trying to following microsoft BizTalk sample Polling data from my Oracle Dabase. The database tables were created successully. I was trying to generate schema for consuming adapter. My oracle version is 11g with most updated patches. When trying to select oracleDBBinding to get POLLINGSTMT, I can not configure my URI (error: connecting to the LOB system has failed. ORA-1017:invalid username/password, logon denied). But I am 100% sure my credentials were entered correctly. However, if I use oracleEBSBinding, I can connect to my database using the exact same credentials. However, I can not find POLLINGSTMT if I use this type of binding. That makes following Microsoft sample extremely difficult.

    If you have come across the same situation, I would appreciate if you could shed some light for me. Is oracleDBBinding not compatible with oracle 11g?

    Thanks,

     

    Wednesday, February 9, 2011 4:24 PM

Answers

  • The errors where it cannot generate the WSDL occur for a couple reasons:

    - The types used in the proc are not compatible with the adapter

    - There is a duplicate or ambiguous name, etc. Be sure to check "generate unique names" as shown on http://msdn.microsoft.com/en-US/library/dd788036(v=BTS.10).aspx.

    You can usually look at the generated WSDL during the wizard (when the error comes up) and this gives you some contextual information to know what went wrong. I would copy the WSDL out and look for where it came to the error.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    • Marked as answer by FrankTo Friday, February 18, 2011 3:29 PM
    Tuesday, February 15, 2011 10:31 PM
    Moderator

All replies

  • Hi FrankTo,

    did you try to enter the username in uppercase? I'm not sure about the ESB binding but the DB binding requires it in uppercase letters (see my blog post here: http://pi.hauth.me/oracle-11g-adapter-installation/).  Another hint could be this post: http://pi.hauth.me/oracle-dataaccess-use-a-different-version/ if you got problems with Oracle.DataAccess.dll version.

    But as you already guessed, the 11g release is (officially) not yet supported. See this page: http://www.microsoft.com/biztalk/en/us/adapter-pack.aspx

     


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

    http://pi.hauth.me

    • Proposed as answer by Narish Wednesday, March 2, 2016 8:07 PM
    Wednesday, February 9, 2011 7:13 PM
  • Oliver,

    Thank you for your response. I found your blog after posting the question. Using the uppercase got me past the login but after adding POLLINGSTMT in the categories and operations box and clicked OK, I got this error: "An error has occurred while retrieving the properties for the selected operation. Retrieval of Operation Metadata has failed while building WSDL at http://MicrosoftLobServices.OracleDB/2007/03/POLLINGSTMT"

    The same error was generated if I selected POLLINGSTMT in the available categories and operations and clicked on Properties. Notification does not have the same issue.

    I have Windows Server 2008 R2 on 64 bit computer. I have installed ODAC and Oracle client 32 bit. I did not installed Oracle Client 64 bit though. Oracle client 32bit was required for my other main application therefore I have not thought about the 64 bit client. Also another reason is I am not sure if 64 bit and 32 bit client can co-exist.

    I would highly appreciate any instruction/hint available.

    Thanks!

    Thursday, February 10, 2011 2:59 PM
  • The errors where it cannot generate the WSDL occur for a couple reasons:

    - The types used in the proc are not compatible with the adapter

    - There is a duplicate or ambiguous name, etc. Be sure to check "generate unique names" as shown on http://msdn.microsoft.com/en-US/library/dd788036(v=BTS.10).aspx.

    You can usually look at the generated WSDL during the wizard (when the error comes up) and this gives you some contextual information to know what went wrong. I would copy the WSDL out and look for where it came to the error.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    • Marked as answer by FrankTo Friday, February 18, 2011 3:29 PM
    Tuesday, February 15, 2011 10:31 PM
    Moderator
  • changing the username to Uppercase worked for me
    • Edited by Narish Wednesday, March 2, 2016 8:07 PM
    Wednesday, March 2, 2016 8:07 PM