SAP Knowledge Base Article - Public

1304015 - Error: "Database Connector Error:42000:[Microsoft][SQL Native Client][SQL Server]......." while refreshing a stored procedure parameter report

Symptom

A Stored Procedure parameter report when trying to refresh popping for an error                                                                                                                                                                                                                                              "Database Connector Error:’42000:[Microsoft][SQL Native Client][SQL Server]Procedure or function ‘Customer’ excepts parameter ‘@CustomerID’,which was not supplied.[Database Vendor Code:201]’ "

Reproducing the Issue

  1. Create a report using Xtreme sample database with a stored procedure parameter.
  2.  Create a sub report, and the sub reports are linked using the parameter from the main report which was created at the stored procedure level to the sub report parameter.
  3.  Modify the names of the stored procedure parameters.
  4.  Set the "Verify Database" Option in Crystal Reports Designer.
  5.  Close the reports and re-open it and try to refresh the report, it throws for an error: "Database Connector Error:’42000:[Microsoft][SQL Native Client][SQL Server]Procedure or function ‘Customer’ excepts parameter ‘@CustomerID’,which was not supplied.[Database Vendor Code:201]’ "
  • Database: SQL Server 2000 / 2005

Resolution

This is a known issue and has been fixed in Service Pack 4 for Crystal reports XIR2 

    Keywords

    KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

    Product

    Crystal Reports 2008 V0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2