WCF-Adapter + Linked Server + ESB

Question

I'm trying to connect all those three things together.

System is Windows Server 2008, Biztalk 2009, ESB, MSSQL 2008.

I have some data in Oracle 10G database, I'm trying to access this data. The scenario I try is the following. I have a View in MSSQL, view selects the data from a Linked oracle server. I consume that data in WCF-custom adapter in Off-Ramp extender using sqlBinding.

Every piece of the puzzle works great separately, but when I try get the data from itinerary, over WCF-Custom (sqlBinding), linked server to Oracle 10g I get the following message:

System.Data.SqlClient.SqlException: The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "RTW" was unable to begin a distributed transaction.

The Distributed Transaction Coordinator is up and running, and accepring remote clients, allows inbound and outbound, does not require any authentication has XA Transactions enabled and works as a NetworkService.


What is that I should configure, enable/disable or read to get what is that needed to get this thing working.

I appritiate any help. Thanks

Answer 1

Hi, Vladimir

Try this:
Reinstalled Oracle Client 10g and selected the checkbox "Oracle Services for
Microsoft Transaction Server" during installation. That installed the
"ORAMTS10.DLL" on the system and shall resolve the issue.

Make a test and let me know if it works for you.

Regards

---

This posting is provided "AS IS" with no warranties, and confers no rights. Microsoft Online Community Support