Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ODBC Driver Behaviour?

Re: ODBC Driver Behaviour?

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 7 Oct 2004 08:51:19 -0700
Message-ID: <bf46380410070851c188c41@mail.gmail.com>


On Thu, 7 Oct 2004 14:11:22 +0100, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
> I'm really hoping that
>
> a) This is known ODBC Driver behaviour and
> b) something can be done about it without touching the code (i.e there
> is a way of modifying the behaviour).
>

Hi Niall,

ODBC is known to do a describe on the table. Dependant on the version you may be able to disable that. Search on MetaLink for ODBC, there's quite a bit there.

It does sound as if the app may be doing a really inefficient rowcount to determine how many rows are available. Not much you can do about that one.

Also, whose ODBC driver is it? Microsofts is sometimes required by apps due to an undocumented ODBC feature that allow PL/SQL index by tables to return collections to ODBC. Oracle's driver does not allow that: it's one of those 'undocumented features of MS software.

If Oracle's, have you downloaded the latest one from MetaLink?

The versions installed with Oracle are usually buggy, or at least buggier than the current ones. :)

Jared

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 07 2004 - 10:47:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US