Skip to Content
0
Former Member
Mar 01, 2011 at 05:24 PM

ODBC Stored Procedure Error

28 Views

Hi all... i have a problem i can't solve....

i have a very very simple stored in my sql server db

CREATE PROCEDURE [dbo].[try]

@Par as int

AS

BEGIN

SET NOCOUNT ON;

SELECT Field1 FROM Table1 WHERE Option=@Par

END

then, i create a simple report. i choose odbc connection and the dsn name. then i added the SP and crystal ask me for the parameter value. then i added the field to the report, print it and save it... and this works fine.

very simple...

now... i need to print "Field2"... so a alter the procedure

SELECT Field1, Field2 FROM Table1 WHERE Option=@Par

open the report and press "verify database"... crystal ask me for parameters and then i have the error

"the table doesn't exists in the database. do you want to remove it?"

i presso no and i have the message "database is ok" and the report works, but without field2..

i also tried to not modify the SP with field2, so just create the report and press "verify database", with no modifications at all... same error!

?????????

obviously this is an example i made to verify if my real report (much more complicated) as a problem, but is not.

with old crystal report 8 no problems! but if i use the report made with cr8 with the 2008 runtime (vb .net 2008 application) the report doesn't work

what shall i do? i can't have a report that i can't modify in the future!!

thanks