Hi! We are connecting to an InterBase database by ODBC to grant for execution some SQL procedures, when the procedures have no parameters it works fine and I can work with them in my CR reports but when the SQL procedures have parameters I get an error message, for example if the procedure name is ProcA, I get the following error message:
HY00: [INTERSOLV][ODBC InterBase driver][InterBase] Dynamic SQL Error, parameter mismatch for procedure ProcA.
It looks like an InterBase error, maybe when you grant the process for execution and it has parameters you have to grant it in a different way that if the process has no parameters, could that be the problem? I didn't find anything in the InterBase forums