Logging to different environments DEV/QA from same crystal report server
How do I pass different environment logging info. I created two dsn's one for dev and one for Qa. Developed all reports using dev dsn.
On crystal report server the database configuration is set to: *Use original database logon information from the report*.
I'm running the report from .net application using Managed RAS. I'm trying to change the logon info here but it errors out saying logon failed.
My code where I'm trying to change logon:
//Connecting to RAS (Report Aplication Server)
EnterpriseService tempService = enterpriseSession.GetService("", "RASReportFactory");
reportAppFactory = (ReportAppFactory)tempService.Interface;
reportClientDocument = reportAppFactory.OpenDocument(infoObject.ID, 0);
// Pass datbase logon credentials
//Initially I was using the line below but changed my code to change data source
// reportClientDocument.DatabaseController.logon(dbUserID, dbPwd);
reportClientDocument.DatabaseController.LogonEx(dbServerName,"", dbUserID, dbPwd);
Please help, do I have to do it different way.