Re: [Firebird-odbc-devel] SQLGetData and bookmarks while using OpenOffice.org

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

On 27.01.2011 10:58, Ocke Janssen wrote:
> Hi,
>
> My name is Ocke Janssen, I'm the project lead of the dba.openoffice.org
> project and I got a problem ;-)
>
> While trying to fetch bookmarks I crash inside the newest ODBC version
> of Firebird.
>
>
>        KernelBase.dll!74edb727()
>        [Frames below may be incorrect and/or missing, no symbols loaded
> for KernelBase.dll]
>        KernelBase.dll!74edb727()
>        OdbcFb.dll!_CxxThrowException(void * pExceptionObject=0x00cfbfe4,
> const _s__ThrowInfo * pThrowInfo=0x0df9f060)  Line 161    C++
>        OdbcFb.dll!IscDbcLibrary::Sqlda::getSqlTypeName()  + 0x23b bytes
>     C++
>        OdbcFb.dll!IscDbcLibrary::Sqlda::getColumnTypeName()  + 0x2b bytes
>      C++
>        OdbcFb.dll!IscDbcLibrary::IscStatementMetaData::getSqlTypeName()
> + 0x16 bytes    C++
>        OdbcFb.dll!OdbcJdbcLibrary::OdbcDesc::defFromMetaDataOut()  + 0xd5
> bytes    C++
>        OdbcFb.dll!OdbcJdbcLibrary::OdbcStatement::prepareGetData()  +
> 0x3a bytes    C++
>        OdbcFb.dll!OdbcJdbcLibrary::OdbcStatement::sqlGetData()  + 0x1e3
> bytes    C++
>        OdbcFb.dll!_SQLGetData@24()  + 0x60 bytes    C++
>        odbc32.dll!5899b7bf()
>   >
> odbcbasemi.dll!connectivity::odbc::OTools::getBytesValue(connectivity::odbc::OConnection
> * _pConnection=0x09978674, void * _aStatementHandle=0x011125b0, long
> columnIndex=0, short _fSqlType=-2, unsigned char&  _bWasNull='
', const
> com::sun::star::uno::Reference<com::sun::star::uno::XInterface>  &
> _xInterface={...})  Line 494 + 0x3a bytes    C++
>
> odbcbasemi.dll!connectivity::odbc::OResultSet::move(connectivity::IResultSetHelper::Movement
> _eCursorPosition=FIRST, long _nOffset=0, unsigned char __formal='
')
> Line 1657 + 0x6e bytes    C++
>
> The SQL_ATTR_USE_BOOKMARKS is VARIABLE (2) and the type which I use for
> SQLGetaData is -2(SQL_C_VARBOOKMARK)
>
> Do you have any hint what I'm doing wrong?
>
> Best regards,
>
> Ocke Janssen
>
>
Hi Ocke,

Do you use Firebird ODBC driver 2.0.0.150 RC2 32-bit?
Do you have any idea how I can reproduce your problem quickly (via 
openoffice or C++ example)?
I have tried to reproduce the problem with IBExpert/ODBC Viewer (it uses 
SQLFetchScroll/SQLGetData), but it works fine.


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