[egenix-users] Re: mxODBC - How do I "set schema"?

[M.-A. Lemburg]

Bob Gibson wrote:
> 
> 
> 
>>...
>>Interesting, so Derby (Cloudscape) and DB2 talk the same
>>wire protocol ?
>>
>>Perhaps you could ask the developers whether the missing
>>rowcount information is per design or simply a bug in the
>>ODBC driver ?!
>>
>>Such information is usually rather important to have, esp.
>>in cases where you want to page through large data sets.
>>
>>Thanks,
>>--
>>Marc-Andre Lemburg
>>eGenix.com
> 
> ----------------------------------------------------------------------
> 
> Marc-Andre:
> 
>   What ODBC calls does mxODBC used to implement the fetchall()?  When
> I look at the ODBC documentation at the Microsmurf site:
> 
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc_api_reference.asp
> 
>   The closest routine I can find is the SQLExtendedFetch Function.  Is
> this what you use?

The 2.0.x version uses SQLFetch(). The 2.1.x which is used in
the mxODBC Zope DA uses SQLFecthScroll() if available and falls
back to plain SQLFetch() if that API is not supported by the ODBC
driver.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Mar 02 2005)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::