ODBC grant for execution SQL procedure

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
aleplgr
Posts: 1
Joined: Wed 14 Feb 2007 09:03

ODBC grant for execution SQL procedure

Post by aleplgr » Wed 14 Feb 2007 09:08

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?
Top
Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Mon 19 Feb 2007 07:23

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.
Top
Post Reply

Return to “InterBase Data Access Components”