Page 1 of 1

ODBC grant for execution SQL procedure

Posted: Wed 14 Feb 2007 09:08
by aleplgr
Hi! I'm trying to connect by ODBC to SQL procedures, it works fine when the SQL procedure has no parameters, but when it has parameters I'm getting the error for example for the SQL procedure nemed procA:

HY00: [INTERSOLV][ODBC InterBase driver][InterBase] Dynamic SQL Error, parameter mismatch for procedure ProcA.

Could it be the problem that when you grant for execution a procedure with parameters you have to use a different instruction that when it has no parameters?

Posted: Mon 19 Feb 2007 07:23
by Alex
We don't provide support for any software products except the CoreLab ones.
It is better to ask your question to the ODBC driver vendor.