Re: [Firebird-odbc-devel] Driver issues

[Martijn T. <m.t...@up...>]

----- Original Message ----- 
From: "Alexander Potapchenko" <ale...@re...>
To: <fir...@li...>
Sent: Wednesday, January 28, 2009 4:23 PM
Subject: Re: [Firebird-odbc-devel] Driver issues


> Martijn Tonies wrote:
>>> DBW3            830-820    ENTER SQLGetData
>>>        HSTMT               03232190
>>>        UWORD                        0
>>>        SWORD                       -2 <SQL_C_BINARY>
>>>        PTR                 <unknown type>
>>>        SQLLEN                     0
>>>        SQLLEN *            0x0578FE68
>>>
>>> DBW3            830-820    EXIT  SQLGetData  with return code -1
>>> (SQL_ERROR)
>>>        HSTMT               03232190
>>>        UWORD                        0
>>>        SWORD                       -2 <SQL_C_BINARY>
>>>        PTR                 <unknown type>
>>>        SQLLEN                     0
>>>        SQLLEN *            0x0578FE68
>>>
>>>        DIAG [HY009] [Microsoft][ODBC Driver Manager] Invalid argument
>>> value (0)
>>>
>>
>> In Delphi, I'm using the ODBCExpress components, what would raise
>> this error?
>>
> It is not a driver of RDBMS.
> The call stack at the level of the Firebird ODBC driver:
> Preparing statement:
> select
>  ID_PRECE
> from
>  "PRECES"
> order by
>  "ID_PRECE"
> SQLFreeStmt
> SQLExecute
> SQLSetStmtAttrW
>    SQL_ATTR_ROWS_FETCHED_PTR = 65213480 : 03E31428
> SQLNumResultCols
> SQLDescribeColW
> Column 01                        ID_PRECE has type 004, scale 000,
> precision 010
> SQLColAttributeW
> SQLBindCol
> SQLColAttributeW
> SQLSetStmtAttrW
> SQLFetch
> SQLSetPos
>
> The next step is a call of SQLGetData function, but there are problems
> (maybe wrong parameters, null pointers) at a upward level (maybe ODBC
> driver manager).
> It is similar to problems in access components(ODBCExpress). You can try
> another components for a work with ODBC (AnyDac free edition,
> http://da-soft.com for example) too.

Replacing the componentset is not an option.

Exactly this code works for other ODBC drivers (although not all, as you
have shown).

I can detect features/ODBC driver functionality though, so if you can figure
out what's wrong, I can try and work around it.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com