Browse by Tags

Hi! I'm using WCF-Oracle Adapter, I'm trying to configure to make a polling every X seconds but when I start the application it gives me the next error: The adapter "Oracledb" raised an error message. Details "Microsoft.ServiceModel.Channels.Common.ConnectionException: Due to an...

Hi Ram, Assuming that you are on BizTalk Server 2006, use the BizTalk Adapter for Oracle DB, that comes with the suite of BizTalk Line of Business Adapters in version 2006. Using that adapter, you should be able to generate your XML schema from the Oracle DB table that you are targeting in your map....

UPDATE: When I activate the receive location with no subscribtions to the received message, polling works fine. I get a message with 5 records in the MessageBox about every 60 seconds. The message get suspended, because there are no subscribtions. When I make a subscribtion to this messages by using...

Hello, I have an Oracle 10g table with about 50 thousand records in it. I want to poll 5 records per minute to BizTalk Server 2006, to process them. I have made a Receive Port and Receive Location to do this. The Connection Properties for this Receive Location are: Delete after poll: True (tested with...

Hello from The Netherlands, We use the BizTalk Oracle adapter in BizTalk Production/Oracle Production and BizTalk Acceptation/Oracle Acceptation environment. Both Query and Insert did work in both environments and gave a QueryResponse and InsertResponse. Oracle Acceptation environment is a clone of the...

Hi I am trying to fetch a record from Oracle DB using Oracle Adapter after giving all transport properties correctly still says " Failed retrieving system ". The Database Service Name which I am using is correct and connection is verified but while in OracleDB Adapter Wizard it gives the error...

I am having this issue with debatching. While fetching data from the database, the oracle adapter also writes the data types in the XML message. Example: <Employees xmlns:xsd=" http://www.w3.org/2001/XMLSchema "> <Employee> <EmployeeName xsi_2001:type="xsd:string" >...

“Pragma” killed the Post-Poll Bembeng Arifin commented on my second post in this series calling out something he had found when working with polling and i decided to follow up on this and in my opinion, the technique is so simple, its absolutely brilliant!! Basically, to avoid some of the...

I got stuck with the complexities of the awful NativeSQL schemas when working with the Oracle ODBC adapter and i thought i had got lucky when i saw a PollingQuery sample but on closer examination of the binding files etc it was clear that the WCF LOB adapter was being used. Very disappointing. I had...