Visual Basic Crystal Reports - Using ConnectionInfo and SetParameterValue does not work in Win2003 server.

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Using ConnectionInfo and SetParameterValue does not work in Win2003 server.

Shelby

2006-01-26, 4:01 am

Hi,

I encounter an error after deployment to customer. However during
development it was working fine.

Development Server: Win 2000 Pro
Production Server: Win 2003 Server

Error Message:
Procedure 'storedProcName' expects parameter '@paramName', which was not
supplied.'

Sample Code:
SetConnectionInfo(myReport, connectionInfo);
myReport.SetParameterValue("@StartDate", pStartDate);
myReport.SetParameterValue("@EndDate", pEndDate);

I did a test on the Win2003 server, I remove away the SetConnectionInfo and
then it will work. But then it will keep prompting me for the UserID and PWD
for SQL Server, which the customer does not want. Is there any setting that
I can do to resolve this?

Thanks,
Shel

Sponsored Links