Re: ODBC Driver Behaviour?

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