Re: Oracle ODBC driver : SQLExtendedFetch() is not supported ?

On Fri, 14 Apr 2000 17:49:17 +0200, Charly le Transalpien <clebrun.no.spam_at_cetiis.fr> wrote:

>
>Hello,
>
>We have that application developped in C, compiled for Windows32 with MS
>Visual C++ 6, using ODBC for database access. We used it for for years
>with some simple databases (like MS-Access, dBase, etc...) and some
>real servers (SQL Server, both Sybase and MS). Now with Oracle we
>encounter this problem :
>
>We have an Oracle 8i server (Oracle 8.1.5.0.0) and client running on
>Windows NT 4 boxes...
>
>When we use the Oracle ODBC driver, we got this error :
>
>---
>SQLExtendedFetch Error1 : [Oracle][ODBC]Optional feature not
>implemented.;
>SQLstate: HYC00
>---
>
>With the latest Intersolv driver for Oracle 8i, we got that error
>(little more precise btw):
>
>---
>SQLExtendedFetch Error1 : [INTERSOLV][ODBC Oracle 8 driver]
>In SQLExtendedFetch, only SQL_FETCH_NEXT is supported for
>SQL_SCROLL_FORWARD_ONLY cursors.;
>SQLstate: HY106
>---
>In both cases, the error occurs in a call to SQLExtendedFetch(). In
>http://www.orafaq.org/faqodbc.htm#COMPLY we learned that Oracle 7 ODBC
>driver doesn't support Level 3 ODBC (SQLExtendedFetch() is of course
>part of it !). Has Oracle 8 driver the same limitation ?

No, the Oracle 8 and 8i drivers support ExtendedFetch. And boy does it make a difference to SQL*Net/Net8's poor network behaviour

Ciao
Fuzzy
:-)   Received on Mon Apr 17 2000 - 00:00:00 CDT