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 Member · Accepted solution]

The place to start is the database documentation. Database Vendor Code messages are being passed through the CR engine unmodified so they do not mean anything to us.

You do mention that the report runs fine... but were? The designer?

See if simplifying will help;

Comment out all code except:

newMakingDuration.ReportDocument.Load(reportPath)

Then of course view or export or print code (that part of the code is missing in your post (e.g.; I'm not sure what you are attempting to do with the report)). E.g.; if viewing:

newMakingDuration.ReportDocument.Load(reportPath)

CrystalReportViewer1.ReportSource = <the report you loaded>

This will force the report to load and prompt for the parameters and db logon. Fill those out and see what happens.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter