I've designed a crystal report which pull data from two separate databases on two separate servers. I'm able to setdatabaselogon to only one of the two databases.
When I deploy the vb.net site with the crystal report I get this error message, "Logon failed. Error in File C:\WINDOWS\TEMP\CorporateAssessment {480C3C41-18FE-4D8A-8B68-E614CCA894B4}.rpt: Unable to connect: incorrect log on parameters."
How do I programmatically set the database logon for two separate databases?
This is my code which does not work. I'm using Visual Studio 2005. My code is vb.net.
CrystalReportSource1.ReportDocument.SetDatabaseLogon("sa", "password", "cacmpm", "Paradigm")
CrystalReportSource2.ReportDocument.SetDatabaseLogon("sa", "password", "cacacls", "ACLS")