Database connector error in Crystal Report when accessing stored procedure

[Former Member]

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