Print Page | Close Window

ODBC grant for execution sql proc

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=209
Printed Date: 20 Apr 2024 at 4:55am


Topic: ODBC grant for execution sql proc
Posted By: aleplgr
Subject: ODBC grant for execution sql proc
Date 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


Replies:
Posted By: BrianBischof
Date 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>


Print Page | Close Window