Skip to Content
0
Former Member
Feb 04, 2011 at 05:56 PM

Issue with changing database location at runtime

34 Views

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...