[Firebird-odbc-devel] Error calling Stored Procedure

[Arno R. <arn...@pl...>]

Hi Vladimir,

I'm testing the Firebird/Interbase ODBC-driver (27.jan.2004) on a Win2K workstation with Firebird 1.5 RC8
The ODBC-driver performs really very well, although I have a problem with Stored Procedures.
When my program calls a stored procedure, with the Gemini ODBC-driver I can receive a result set, with Firebird/Interbase I do not receive a result set.

Can you explain why with the ODBC-trace below?

Thanks in advance,

Arno Rog
Amsterdam

Trace:
====

Gemini Interbase ODBC-driver
busine~1        454-72c	ENTER SQLPrepare
		HSTMT               01134A50
		UCHAR *             0x01951118 [      -3] "{CALL SP_CALC_TOTDEBNR(103429,0,?,?,?,?,?,?)}\ 0"
		SDWORD                    -3

busine~1        454-72c	EXIT  SQLPrepare  with return code 0 (SQL_SUCCESS)
		HSTMT               01134A50
		UCHAR *             0x01951118 [      -3] "{CALL SP_CALC_TOTDEBNR(103429,0,?,?,?,?,?,?)}\ 0"
		SDWORD                    -3

busine~1        454-72c	ENTER SQLColAttributes
		HSTMT               01134A50
		UWORD                        0
		UWORD                        0 <SQL_COLUMN_COUNT>
		PTR                0x00000000
		SWORD                        0
		SWORD *             0x00000000
		SQLLEN *            0x0174F77C
------------------------------------------------------------
Firebird/Interbase ODBC-Driver (27.jan.2004)
busine~1        484-198	ENTER SQLPrepare
		HSTMT               01133AB8
		UCHAR *             0x01AA1118 [      -3] "{CALL SP_CALC_TOTDEBNR(103429,0,?,?,?,?,?,?)}\ 0"
		SDWORD                    -3

busine~1        484-198	EXIT  SQLPrepare  with return code -1 (SQL_ERROR)
		HSTMT               01133AB8
		UCHAR *             0x01AA1118 [      -3] "{CALL SP_CALC_TOTDEBNR(103429,0,?,?,?,?,?,?)}\ 0"
		SDWORD                    -3

		DIAG [HY000] Dynamic SQL Error
parameter mismatch for procedure SP_CALC_TOTDEBNR (335544569)

busine~1        484-198	ENTER SQLErrorW
		HENV                01131250
		HDBC                011312F8
		HSTMT               01133AB8
		WCHAR *             0x0199F660 (NYI)
 		SDWORD *            0x0112768E
		WCHAR *             0x0199F260
		SWORD                      511
		SWORD *             0x0199F6BA