Hi. I'm not able to display the report..
I'm preparing the production server:
. i've installed s.o. = Windows Server 2003 with all patches
. i've added the application role (II6)
. i've installed last runtime for Crystal Report 2008 and .net = CRRuntime_12_1_mlb.msi
. i've deployed my aaplication on the default web site
Result: the site's pages works fine except for displaying my reports! In the position of the report appears a message (in italian: Accesso al database non riuscito) like database access failed..
I don't understand the cause:
- i'm using the same sources working fine on 2 other environment machine (Vista SP1 and another Windows Server 2003)
- the user for database login is written in code, like the Microsoft practices:
private void SetDBLogonForReport()
{
ConnectionInfo conn = new ConnectionInfo();
//conn.Type = ConnectionInfoType.SQL;
conn.ServerName = "name_server";
conn.DatabaseName = "name_db";
conn.UserID = "user";
conn.Password = "pwd";
TableLogOnInfo LInfo = new TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table table in myReport.Database.Tables)
{
LInfo = table.LogOnInfo;
LInfo.ConnectionInfo = conn;
table.ApplyLogOnInfo(LInfo);
}
}
- the app don't cause exceptions (i've run it in debug mode directly on the server without problems
Maybe the message is misleading and the cause is not about db?
Thanks