Re: ODBC Pass Through SQL to Oracle Express 10g

<div class="mail">
<address class="headers">
<span id="from">
<dfn>From</dfn>: joel garry <joel-garry_at_home.com>
</span>
<span id="date"><dfn>Date</dfn>: 3 Jul 2006 11:42:10 -0700</span>
<span id="message-id"><dfn>Message-ID</dfn>: <1151952130.565061.37240_at_b68g2000cwa&#46;<!--nospam-->googlegroups.com>
</span>
</address>

Greg Strong wrote:
<br>
<i class="quotelev1">> Hello All,</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">> I don't know if this is an appropriate topic here, but I'll ask the</i><br>
<i class="quotelev1">> question. Maybe one of you can help. I've been banging my head on this</i><br>
<i class="quotelev1">> one for a while.</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">> I'm experimenting with using Access 2k2 as a front end to Oracle</i><br>
<i class="quotelev1">> Express. I am creating 10 tables using pass through DDL queries. The</i><br>
<i class="quotelev1">> PROBLEM is the general format of the VB code WORKS on the 1st 6 tables</i><br>
<i class="quotelev1">> created, then an error is thrown which I can't find much help on. I've</i><br>
<i class="quotelev1">> compared the code on the 7th table to earlier ones which are successful,</i><br>
<i class="quotelev1">> and the general format is the same. It seems the more you try, the</i><br>
<i class="quotelev1">> quicker the problem is created. Re-booting fixes the problem, but the</i><br>
<i class="quotelev1">> error always 1st occurs on the 7th table with subsequent tries occurring</i><br>
<i class="quotelev1">> quicker. On subsequent tries I always drop the tables with cascading</i><br>
<i class="quotelev1">> constraints and a purge. The specifics are below. Any ideals?</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">> Thanks!</i><br>
<i class="quotelev1">></i><br>

Metalink Note:135313.1 says nested transactions are not supported with ODBC, and shows how to simulate with savepoints. It refers to Microsoft Knowledge Base Q177138
<br>
<a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;Q177138">http://support.microsoft.com/default.aspx?scid=kb;en-us;Q177138</a> which
basically says, tough, unless you use the Jet engine.

But I wouldn't know anything about it.

jg

--
@home&#46;<!--nospam-->com is bogus.
Needs a bigger pipe:  <a href="http://blog.wired.com/27BStroke6/?entry_id=1512499">http://blog.wired.com/27BStroke6/?entry_id=1512499</a>


<span id="received"><dfn>Received on</dfn> Mon Jul 03 2006 - 13:42:10 CDT</span>

</div>