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

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

On 07.03.2011 17:50, Alexander Potapchenko wrote:
> 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.
>>
> 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.
>
After the additional analysis of the driver source code I have found 
wrong and implicit type conversion of the cursor (conversion to type 
SQL_CURSOR_FORWARD_ONLY). Please create issue in the bug tracker - 
http://tracker.firebirdsql.org/browse/ODBC about your problems with the 
driver in the Open Office.

Regards,
Alexander

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