RE: ODBC connection - extra statements being run

From: McCartney, Bruce <bruce.mccartney_at_dbinfosystems.com>
Date: Wed, 8 Feb 2006 15:02:04 -0700
Message-ID: <9ABF8624-EB04-4652-98A0-9A764708BAC4@mimectl>

John,
Some ODBC drivers execute extra statements to determine data types of columns and what not. Which driver are you using? Try using a newer ODBC driver. Did you trace timed events in the 10046 trace? What is it waiting on?

From: Fedock, John (KAM.RHQ)
Sent: Wed 2/8/2006 1:46 PM
To: oracle-l_at_freelists.org; oracledba_at_LazyDBA.com Subject: ODBC connection - extra statements being run

When a user connects to my HP-UX 10g database from Excel via ODBC and runs a SQL select statement joining 2 tables, a 10046 trace clearly shows that statement running quickly, then another mysterious statement running, which is basically a select from the 2 tables with no join. This causes it to run for more than 10 minutes. The original statement runs < 2 second in SQLPLUS. Can anyone explain? Thanks all,

John Fedock
K Line America, Inc.
john.fedock <at> us.kline.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 08 2006 - 16:02:04 CST