none
Oracle DB access through WCF RRS feed

  • Question

  • Hello there,

    Example: Connect to OracleDB and execute a select using consume adapter

    I'm having issues connecting to an Oracle DB using adapter, I have tried the samples from msdn [http://msdn.microsoft.com/en-us/biztalk/dd796258] and looking at the tracking I get that the message is sent but I don't get a response from the server. However, I can use the wizard to connect to the server and I'm able to get the DB name, services, packages, everything... but when I run the application I don't receive a response.

    What might I be missing? What other info would you need to understand better what I'm trying to do?

    Thanks in advance!

     

    Carlos

    Thursday, September 22, 2011 11:16 AM

Answers

  • Hi Carlos,

    You can look at my post on table operations with OracleDB. I have moved question to BizTalk Server Adapters and Adapter Pack as question suits better here.

    HTH

    Regards,

    Steef-Jan Wiggers
    MVP & MCTS BizTalk Server 2010
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    • Marked as answer by CarlosEd Thursday, September 22, 2011 2:48 PM
    Thursday, September 22, 2011 11:20 AM
    Moderator

All replies

  • Oh, thanks Steef-Jan. Sorry for the mistaken cat.

    ----------------------

    I have actually downloaded the sample from: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=4675

    Which are specific for BTS2010

    Thursday, September 22, 2011 11:20 AM
  • Hi Carlos,

    You can look at my post on table operations with OracleDB. I have moved question to BizTalk Server Adapters and Adapter Pack as question suits better here.

    HTH

    Regards,

    Steef-Jan Wiggers
    MVP & MCTS BizTalk Server 2010
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    • Marked as answer by CarlosEd Thursday, September 22, 2011 2:48 PM
    Thursday, September 22, 2011 11:20 AM
    Moderator
  • Start with a select operation. You should be able to get the response back. For logging and tracing see this article:http://msdn.microsoft.com/en-us/library/cc185303(v=bts.10).aspx
    Regards,
    Bali
    MCTS: BizTalk Server 2010,BizTalk Server 2006 and WCF
    Blog: http://dpsbali-biztalkweblog.blogspot.com
    -----------------------------------------------------
    Mark As Answer or Vote As Helpful if this helps.
    Thursday, September 22, 2011 11:29 AM
  • Hi,

    To add to Bali suggestion on logging and tracing I like to suggest using BizTalk CAT Framework, see my post on guidance.

    HTH

    Regards,

    Steef-Jan Wiggers
    MVP & MCTS BizTalk Server 2010
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    Thursday, September 22, 2011 11:40 AM
    Moderator
  • Thanks a lot guys, I'll be reading and trying to implement your suggestions for a while... 

     

    I'll get back to you ASAP

     

    Dank je wel!

    Thursday, September 22, 2011 11:45 AM
  • hmm, it seems that we don't have enough time to get on with the BizTalk CAT Framework, even worse... it looks like we abandon the idea of using adapters to connect to oracle DBS, at least for the moment, due to short timimg. We will use external assemblies calling to import datasets into the orchestration. I guess I will be posting a new question about how to convert a dataset into a message, so we can treat it.
    Thursday, September 22, 2011 12:18 PM
  • If you wana do it quickly WCF Adapter would be the best bet, however if you are doing it for the first time it would need some ramp up time.
    Regards,
    Bali
    MCTS: BizTalk Server 2010,BizTalk Server 2006 and WCF
    Blog: http://dpsbali-biztalkweblog.blogspot.com
    -----------------------------------------------------
    Mark As Answer or Vote As Helpful if this helps.
    Thursday, September 22, 2011 12:29 PM
  • So far, my experience with BizTalk has been rather frustrating, advancing just a tiny bit after a lot of efforts put into every task, I really wish the learning curve was less steep.

    If I could only solve this connecting to DB server thing...

    Thursday, September 22, 2011 12:30 PM
  • I don't get it... not even the WCF adapter's sample from msdn works in my environment, it is an OracleServer 10.2 , I'm running BTS 2010, with SQLS2008

    I have ran the sql scripts, everything executed just fine, then opened the solution... deployed it, imported the binding file, changed the server bindings to my server, set "enableBizTalkCompatibilityMode" = True and "useAmbientTransaction" = False, changed the receive location and the sendport location... and still doesn't work. I mean, it should, right?

    Thursday, September 22, 2011 12:39 PM
  • Alright, I have an advise. When you're obfuscated with a problem, go have lunch... I came back and saw that I was missing changing the namespace in the generated schema. It's up and running now.

    Thanks a lot!

    Thursday, September 22, 2011 2:47 PM