Skip to Content
0
Former Member
Jul 17, 2008 at 06:22 AM

How Store procedure will be used in crystal report?

170 Views

Hi Support,

I have created a store procedure in SQL server 2000 and i would like to retrieve it from crystal report but it shows error when i want to drag the store procedure to the selected table area.

The error is

Database connector error: 'ADO Error Code:0x80040e09

source: microsoft OLE DB Provider for SQL server

Description: Execute permission denied on object 'PartListbybuyer_800', database 'erplndb', owner 'dbo'.

Sql State: 42000

Native error: 229 [Database Vendor Code:229]'

Appreciate your prompt reply. Thanks