Skip to Content
0
Former Member
Nov 18, 2008 at 05:58 PM

Unable to SetDatabaseLogon for two separate database

260 Views

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")