Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure with no Parameters

Status
Not open for further replies.

doodledump

Programmer
Sep 4, 2024
4
I just recently updated from Visual Studio 2013/ Crystal reports SP35 to Visual Studio 2022/ Crystal Reports SP36 and have run into an unexpected problem. When I try to run one of my newly converted reports, I get the error: "Failed to retrieve data from database, Unexpected number of arguments from PROCEDURE; expected 0, got 1". When I look at the SQL query being run, it shows CALL database.procedure(NULL) - I'm assuming the NULL is being read as an argument but I don't know how to remove it. It ran just fine in VS13 so I'm assuming its a setting I'm missing on the newer version?
 
Try creating a Command to run the stored proc instead of using Crystal's default sp behavior.

-Dell
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top