[Firebird-odbc-devel] Invalid parameter in transaction parameter block FB 2.1.1

[Alexandre B. S. <ib...@th...>]

Guys,

I had upgraded my development server to 2.1.1, now I am in trouble with 
Crystal Reports (ODBC Connection). I use a pretty old Crystal Report 
version (version 7).

Everything always worked like a charm with ODBC and FB (Beta 0.9, 1.0, 
1.5, 2.0) now 2.1 has "problems", another guy have the same problem with 
FireRuby Driver (reported on fb-support) Dmitry Yemanov replied that FB 
2.1 has a stricter checking on TPB values and that is some bug on 
FireRuby driver.

I have no choice in Crystal Reports to set any kind of parameter in TPB.

Any ideas how can I try to solve this ?

I had looked on ODBC trace log, but did not understand the details (like 
when it's defining the TPB values, and with which values)

If I send the ODBC log someone could take a look on it ?

The relevant parts I think is this:
crw32           bf4-5b8    EXIT  SQLGetInfoW  with return code 0 
(SQL_SUCCESS)
        HDBC                023215E8
        UWORD                       17 <SQL_DBMS_NAME>
        PTR                 0x02321780 [      16] "Firebird"
        SWORD                      510
        SWORD *             0x0013D804 (16)

crw32           bf4-5b8    ENTER SQLGetInfoW
        HDBC                023215E8
        UWORD                       72 <SQL_TXN_ISOLATION_OPTION>
        PTR                 0013D808
        SWORD                        4
        SWORD *             0x0013D804

crw32           bf4-5b8    EXIT  SQLGetInfoW  with return code 0 
(SQL_SUCCESS)
        HDBC                023215E8
        UWORD                       72 <SQL_TXN_ISOLATION_OPTION>
        PTR                 0013D808
        SWORD                        4
        SWORD *             0x0013D804 (4)

crw32           bf4-5b8    ENTER SQLSetConnectOption
        HDBC                023215E8
        SQLINTEGER                 108 <SQL_TXN_ISOLATION>
        SQLPOINTER          0x00000001

crw32           bf4-5b8    EXIT  SQLSetConnectOption  with return code 0 
(SQL_SUCCESS)
        HDBC                023215E8
        SQLINTEGER                 108 <SQL_TXN_ISOLATION>
        SQLPOINTER          0x00000001 (BADMEM)

crw32           bf4-5b8    ENTER SQLGetInfoW
        HDBC                023215E8
        UWORD                        2 <SQL_DATA_SOURCE_NAME>
        PTR                 0x02321780
        SWORD                      510
        SWORD *             0x0013D924

crw32           bf4-5b8    EXIT  SQLGetInfoW  with return code 0 
(SQL_SUCCESS)
        HDBC                023215E8
        UWORD                        2 <SQL_DATA_SOURCE_NAME>
        PTR                 0x02321780 [       8] "Odin"
        SWORD                      510
        SWORD *             0x0013D924 (8)

the above is in the beginning of the log...

and this one at the end:
crw32           bf4-5b8    EXIT  SQLAllocStmt  with return code 0 
(SQL_SUCCESS)
        HDBC                023215E8
        HSTMT *             0x02450E94 ( 0x02321b98)

crw32           bf4-5b8    ENTER SQLPrepare
        HSTMT               02321B98
        UCHAR *             0x02450A80 [      -3] "SELECT 
FERIADO.FERIADOID, FERIADO.DATA, FERIADO.DESCRICAO FROM FERIADO FERIADO 
WHERE FERIADO.DATA >= ? AND FERIADO.DATA <= ? ORDER BY FERIADO.DATA ASC\ 0"
        SDWORD                    -3

crw32           bf4-5b8    EXIT  SQLPrepare  with return code -1 (SQL_ERROR)
        HSTMT               02321B98
        UCHAR *             0x02450A80 [      -3] "SELECT 
FERIADO.FERIADOID, FERIADO.DATA, FERIADO.DESCRICAO FROM FERIADO FERIADO 
WHERE FERIADO.DATA >= ? AND FERIADO.DATA <= ? ORDER BY FERIADO.DATA ASC\ 0"
        SDWORD                    -3

        DIAG [HY000] [ODBC Firebird Driver][Firebird]invalid parameter 
in transaction parameter block (-901)

crw32           bf4-5b8    ENTER SQLErrorW
        HENV                02321540
        HDBC                023215E8
        HSTMT               02321B98
        WCHAR *             0x0013E00C (NYI)
         SDWORD *            0x0013E058
        WCHAR *             0x0013DC0C
        SWORD                      242
        SWORD *             0x0013E056

crw32           bf4-5b8    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                02321540
        HDBC                023215E8
        HSTMT               02321B98
        WCHAR *             0x0013E00C (NYI)
         SDWORD *            0x0013E058 (-901)
        WCHAR *             0x0013DC0C [      80] "[ODBC Firebird 
Driver][Firebird]invalid parameter in transaction parameter block"
        SWORD                      242
        SWORD *             0x0013E056 (80)


The full log is 108k unzipped, 4k zipped.

TIA

see you !

-- 
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br