Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: ODBC grant for execution sql proc Post Reply Post New Topic
Author Message
aleplgr
Newbie
Newbie


Joined: 09 Dec 2006
Online Status: Offline
Posts: 23
Quote aleplgr Replybullet Topic: ODBC grant for execution sql proc
    Posted: 13 Feb 2007 at 1:27am

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

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 13 Feb 2007 at 9:46am
Sorry, I've never worked with InterBase before. Maybe someone else here has?
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.