Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!b68g2000cwa.googlegroups.com!not-for-mail From: "joel garry" Newsgroups: comp.databases.oracle.server Subject: Re: ODBC Pass Through SQL to Oracle Express 10g Date: 3 Jul 2006 11:42:10 -0700 Organization: http://groups.google.com Lines: 35 Message-ID: <1151952130.565061.37240@b68g2000cwa.googlegroups.com> References: NNTP-Posting-Host: 67.116.125.178 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1151952134 11303 127.0.0.1 (3 Jul 2006 18:42:14 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 3 Jul 2006 18:42:14 +0000 (UTC) In-Reply-To: User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.0 ISA2K4-OC1 Complaints-To: groups-abuse@google.com Injection-Info: b68g2000cwa.googlegroups.com; posting-host=67.116.125.178; posting-account=YRNZ5wwAAAAg-yYjMFwy3FyWUbPiwNdq Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270267 Greg Strong wrote: > Hello All, > > I don't know if this is an appropriate topic here, but I'll ask the > question. Maybe one of you can help. I've been banging my head on this > one for a while. > > I'm experimenting with using Access 2k2 as a front end to Oracle > Express. I am creating 10 tables using pass through DDL queries. The > PROBLEM is the general format of the VB code WORKS on the 1st 6 tables > created, then an error is thrown which I can't find much help on. I've > compared the code on the 7th table to earlier ones which are successful, > and the general format is the same. It seems the more you try, the > quicker the problem is created. Re-booting fixes the problem, but the > error always 1st occurs on the 7th table with subsequent tries occurring > quicker. On subsequent tries I always drop the tables with cascading > constraints and a purge. The specifics are below. Any ideals? > > Thanks! > 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 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q177138 which basically says, tough, unless you use the Jet engine. But I wouldn't know anything about it. jg -- @home.com is bogus. Needs a bigger pipe: http://blog.wired.com/27BStroke6/?entry_id=1512499