Error on reporting services

I am using VS 2003 + SQL Server 2000 Reporting services.

When i want to print the report, clicking the trigger button, and pop up a browser and get the following error.

Error occurs when handling the report (rsProcessingAborted)

Request on dataset 'PG' fails (rsErrorExecutingCommand)

Must declare the variable'@.qcode'.

- I already got qcode in my url link... i would like to know what's the problems about.

Thank you.

Hi,

Can you run this report successfully when you browse the report in the VS.NET IDE?

I think, you are passing a parameter which is not declared in the stored procedure. Are you using a stored procedure as the datasource of the dataset PG by the way?

Since you have the parameter qcode in the url, either this parameter is not defined in the report or is not defined in the SP.

You know, while naming parameters in SQL RS, you do not use the "@." preior the parameter name, but you use it within the sql SP.

Eralper

http://www.kodyaz.com

Error message

I have installed the the MSSQL Server 2000 along with its
service pack 2. However, I am getting an error message
(pop window) that says:
isqlw.exe - Ordinal Not Found
"The ordinal 29 could not be located in the dynamic link
library odbcbcp.dll"
Please help me resolve this issue.
ThanksThe error is usually caused by MDAC issues (mismatched
dlls). Try applying the latest service pack (SP3a) or
reapply you mdac version. You can check versions with the
component checker. The component check and recent MDAC
versions are available for download from:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Thu, 22 Apr 2004 13:06:36 -0700, "Ashraf"
<anonymous@.discussions.microsoft.com> wrote:

>I have installed the the MSSQL Server 2000 along with its
>service pack 2. However, I am getting an error message
>(pop window) that says:
>isqlw.exe - Ordinal Not Found
>"The ordinal 29 could not be located in the dynamic link
>library odbcbcp.dll"
>Please help me resolve this issue.
>Thanks
>

Error message

I have installed the the MSSQL Server 2000 along with its
service pack 2. However, I am getting an error message
(pop window) that says:
isqlw.exe - Ordinal Not Found
"The ordinal 29 could not be located in the dynamic link
library odbcbcp.dll"
Please help me resolve this issue.
Thanks
The error is usually caused by MDAC issues (mismatched
dlls). Try applying the latest service pack (SP3a) or
reapply you mdac version. You can check versions with the
component checker. The component check and recent MDAC
versions are available for download from:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Thu, 22 Apr 2004 13:06:36 -0700, "Ashraf"
<anonymous@.discussions.microsoft.com> wrote:

>I have installed the the MSSQL Server 2000 along with its
>service pack 2. However, I am getting an error message
>(pop window) that says:
>isqlw.exe - Ordinal Not Found
>"The ordinal 29 could not be located in the dynamic link
>library odbcbcp.dll"
>Please help me resolve this issue.
>Thanks
>