Re: ODBC Pass Through SQL to Oracle Express 10g

On 3 Jul 2006 11:42:10 -0700, "joel garry" <joel-garry_at_home.com> wrote:

>It refers to
>Microsoft Knowledge Base Q177138
>http://support.microsoft.com/default.aspx?scid=kb;en-us;Q177138 which
>basically says, tough, unless you use the Jet engine.

After doing a little research I think the fact the transactions running consecutively DOES in fact create nested transaction because they probably were NOT committed in the back end Oracle DB before receiving the additional SQL. Maybe I'll have to try ADO rather than DAO. This is an interesting read:

http://support.microsoft.com/kb/q187289/

Thanks!

-- 
Regards,

Greg Strong