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

[Steve B. <sbo...@gm...>]

Done.  ODBC-115.


Alexander Potapchenko wrote:
> 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
>
>