Skip to Content
author's profile photo
Former Member

Failed to retrieve data from the database

Hello All,

In my stored proc.

I have two decalred parameters as follow:

@AsOfDate varchar (20),

@Entity varchar(8000)= null

at the end of my select statement I have the following code:

WHERE (CPL.Effective_Date = convert (datetime,@AsOfDate) AND (CPD.Src_Intfc_Inst = dbo.udf_wb_GetSourceInstance('STARDIRECT'))

and (CE.Entity_Name = @Entity)

when i run the stored proc in SQL server management I get prompted to enter my parameters it works fine.

when I tried createing my report using (Crystal Report 11.5) the parameter prompter request my parameters but I get error.

failed to retrieve data from the database

detail ado error code ox

@asofdate which was not supplied

Native error [database vendor code:201]

I did create my parameter in crystal is that required ? Since I have it in my stored Proc.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Sep 03, 2008 at 02:23 AM

    Did you get it working?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2009 at 03:09 PM

    Need more info, Version of CR and SQL Server etc.

    Please re-post if this is still an issue to the Data Connectivity - Crystal Reports Forum or purchase a case and have a dedicated support engineer work with you directly

    Add comment
    10|10000 characters needed characters exceeded