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 Mike Lewis 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

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
 

Part and Inventory Search

Sponsor

Back
Top