Re: ODBC Driver Behaviour?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Thu, 7 Oct 2004 08:51:19 -0700
On Thu, 7 Oct 2004 14:11:22 +0100, Niall Litchfield
<niall.litchfield@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
