Hi,

Firebird 1.5, ODBC_2.0.0.148_win32 and Delphi 2009

In using the select procedure 'select * from <procname>' with 1 no. integer input parameter I get the following error message:

[ODBC Firebird Driver][Firebird] Dynamic SQL error
parameter mismatch for procedure <procname>

This message occurs whether I use the TADO Command, Query or Dataset components. In using each of these the debugger shows the parameter datatype being 'ftInteger', which is as required.

Does anybody know why the mismatch occurs?

Using a TADOquery component works, as does the TADOCommand with CommandType = cmdStoredProc. It seems as though the ODBC driver is expecting the input parameter to be of a different datatype: in which case which type?

Am I doing something incorrectly, or is this a bug?

Thanks in advance.

Brian Gooch.