I have created a stored procedure in MS SQL Server 2005 with one input parameter and three output parameters. I have executed the query successfully in SQL Server. Now I am trying to built a report using this stored procedure. When I select the stored procedure in Crystal Reports database expert it prompts for the input and output parameters. When I enter them and press OK then I get the following error.
Database Connector Error:
'Cannot obtain error message from server.'
My first question is how should I pass the output parameter, I have declared the output parameters as VARCHAR(10) in stored procedure in SQL server.
So, do I have to pass it as for eg. @rate OR {?rate} OR rate.
I don't think I have any problems with ODBC drivers or Grants.
If I create a stored procedure with on output paratmeters, I have no issues. I am able to add it to the datasource and get the data in the report.
I feel I am having issue only with the output parameters. Did I miss anything?
Can anyone please help me.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |