Database Vendor Code 102

[Former Member]

So I am getting the below error.

I have verified the database in my report several times and reset the datasource location.   The report run a preview just fine.  So that seems to tell me that it has no problem connecting to the database and running the sql query.

I am loading and sending parameters to the report as follows...

        parmPCname = Session("pcname")

        parmReportDate = Session("productionDate")

        reportPath = Server.MapPath("MakingDuration.rpt")

        newMakingDuration.ReportDocument.Load(reportPath)

        newMakingDuration.ReportDocument.SetDatabaseLogon(username, password, server, database)

        newMakingDuration.ReportDocument.SetParameterValue("pcname", parmPCname)

I am using CR version 13 patch 10 in VS2013

Anyone have any ideas on the above error message?

thanks

doug

[former_member11696]

Try formatting the parameter using this way or what ever type it is:

newMakingDuration.SetParameterValue("pcname", Convert.ToString(parmPCname));

The error means you are not formatting the value properly or the log on info is incorrect. CR is simply passing the error from the Client to you.

Don

[Former Member]

Thanks Don and Ludek for the assistance.

I was able to get past this by recreating the report from scratch and creating a stored procedure in my SQL Server 2012 db.  Before I simply was using a SQL query command in the report and I think something to do with how I created the parameter was causing the query to not run.  It works great with a stored procedure.

thanks again