Re: [Firebird-odbc-devel] ODBC standard version support

[Alexander P. <ale...@gm...>]

On 07.03.2011 16:43, Stephen Boyd wrote:
> Can anyone tell me what version of the ODBC standard the Firebird ODBC driver supports?  I am running into problems trying to use Firebird ODBC (2.0.150) with Open Office 3.3, which claims to only support version 3 of ODBC.
>
Firebird ODBC driver supports ODBC standard 3.
I have tried to use Open Office 3.3 and I have problem with select from 
table - "Fetch type out of range". It is a problem in Open Office.
You can look at SQLFetchScroll function description - 
http://msdn.microsoft.com/en-us/library/ms714682%28v=vs.85%29.aspx. The 
value of the SQL_ATTR_CURSOR_TYPE statement attribute was 
SQL_CURSOR_FORWARD_ONLY, and the value of argument FetchOrientation was 
not SQL_FETCH_NEXT.
Open Office 3.3 uses SQL_CURSOR_FORWARD_ONLY and SQL_FETCH_FIRST 
simultaneously.
It is necessary to wait for the new version of Open Office.

Regards,
Alexander
-- 
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru