PC 客户端上的 C# Crystal Report 总是询问登录提示 SQL Server

Question

创建setup我的程序，程序运行良好，可以crud数据库。

打开报表时，总是出现登录提示的问题。但在数据库字段中为空禁用。

在服务器计算机上，报告没有问题。

在我建立连接的代码中，像这样

cnn.ServerName = @"179.15.30.74\SQLEXPRESS";
cnn.DatabaseName = "db_test";
cnn.UserID = "sa";
cnn.Password = "123";

如何禁用登录提示？

[已解决]我在pc客户端安装sql native client https://www.microsoft.com/en-us/download/details.aspx?id=16978

Answer 1

你必须像这样设置参数来报告:

ReportDocument cryRpt = new ReportDocument();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables ;
cryRpt.Load("PUT CRYSTAL REPORT PATH HERE\CrystalReport1.rpt");
crConnectionInfo.ServerName = "YOUR SERVER NAME";
crConnectionInfo.DatabaseName = "YOUR DATABASE NAME";
crConnectionInfo.UserID = "YOUR DATABASE USERNAME";
crConnectionInfo.Password = "YOUR DATABASE PASSWORD";

CrTables = cryRpt.Database.Tables ;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
    crtableLogoninfo = CrTable.LogOnInfo;
    crtableLogoninfo.ConnectionInfo = crConnectionInfo;
    CrTable.ApplyLogOnInfo(crtableLogoninfo);
}

crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();