Maybe I'm having a bad monday morning, but I don't see what the question has to do with the subject of the thread.

Is it me or this guy has a special ability in obscure questions?

He gave the sample data, at least...

Edit: fixed broken link

Peso, I don't understand your answer as well as I don't understand the question.

Can you clarify?

It didn't look like it...

Glad you put it to work, congrats!

I'm sorry, I'm never been there so in depth.

Hope somebody else can give it a look.

Conegliano, near Venice, Italy.

We have electric power, tv, Internet and SQL Servers of course.

I'm not a member of the Mafia, I don't ride a Vespa, I'm not wearing a pinstripe...

Yes, MSDAORA supports distributed transactions.

As you have checked all possible documentation available, I suppose you already have read this:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;280106

If your Oracle is on Windows, take a look at this:

http://support.microsoft.com/?scid=kb;en-us;817064&x=18&y=14

Also check network connectivity. MSDTC works on the RPC port (135) and it must be reachable in order to make it work.

I don't know if this is the case when...

If you are joining the orders just to filter your data, you could use WHERE EXISTS:

SELECT STK_STOCK_2.STKCODE2 AS [Stock Code],

STK_STOCK_2.STK_SANALYSIS1 AS [Price...

Check the settings on the Oracle side: is it configured for two-phase commit? I think this is an option on the provider.

Try grouping the OR conditions in parenthesis:

SELECT STK_STOCK_2.STKCODE2 AS [Stock Code], STK_STOCK_2.STK_SANALYSIS1 AS [Price Line 1], STK_STOCK_2.STK_SANALYSIS2 AS [Price Line 2],

...

Oh! Thanks Jeff, only time will tell...

Thanks for the update! So, are you calling stored procedures directly or are you using staging tables populated by stored procedures? I think this is the main focus of this...

I know for sure versions 8.5, 9, 10 and XI behave this...