Hi,
My crystal reports are connected to SQL Server 2008 using an OLE DB connection. Everything works great...but if I try to run the report on a different SQL server, the report just hangs up. I am setting the database connection at runtime using Report Document.
I do something similar to this:
onnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.ServerName =(sqlServerName)
connectionInfo.DatabaseName = (databaseName)
connectionInfo.IntegratedSecurity = true;
table.LogOnInfo.ConnectionInfo = connectionInfo;
What am I doing wrong? or what am I missing?
Any help/guidance would be appreciated!
Thanks...