Stored Procedure Problem

[npongar]

Hello everyone,

I am having a problem returning data to a Crystal Report from a SQL Server stored procedure. I am building my report in VS 2005. I have successfully created a OLE DB connection to my database, and have no problems returning data from tables and views. Whenever I try to return data from a stored procedure though I recieve this error:

Query Engine Error: 'ADO Error Code: 0x
Source: Microsoft OLE DB Provider for SQL Server
Description: Line 1: Invalid procedure number (0). Must be betweeen 1 and 32767.
SQL State: 42000
Native Error:'

This error shows up after I exit the form for setting the parameters inthe stored procedure. Also, when I am looking at the list of available stored procedures in the ADO DB view, all of them have the number zero at the end, like this:

dbo.StoredProcedureName;0

If anyone can help clarify what this problem is and hopefully tell me how to fix it, that would be just awesome.

 

[dgillz]

Can you view the records of the stored procedure in SQL query analyzer without problems?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry