Crystal：无法在客户端计算机上打开Connection [英] Crystal: Failed to open Connection on client machine

问题描述

That is my app.config file <pre lang="HTML"><?xml version="1.0"?>
<configuration>
  <connectionStrings>
    <add name="con" connectionString="Data Source=Laptop\SQLEXPRESS;user=sa;PASSWORD=abcd1234;Initial Catalog=FINAl;Integrated Security=True"/>
  </connectionStrings>
  <appSettings>
  </appSettings>
<startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0" />
  </startup>
</configuration></pre>

C# Code
<pre lang="c#">
String ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["con"].ConnectionString.ToString();
ReportDocument cryRpt = new ReportDocument();
string file = Application.StartupPath + "\\Reports\\BuiltyDateWise.rpt";
SqlConnectionStringBuilder sqlconn = new SqlConnectionStringBuilder(ConnectionString);
cryRpt.Load(file);
cryRpt.SetParameterValue("@FromDate", txtFromDate.Text.Replace("/", "-"));
cryRpt.SetParameterValue("@ToDate", txtToDate.Text.Replace("/", "-"));
cryRpt.SetDatabaseLogon(sqlconn.UserID, sqlconn.Password, sqlconn.DataSource, sqlconn.InitialCatalog);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();

这是我的代码在我的机器上工作正常但不能在其他机器上工作。

新连接字符串工作在我在客户端计算机上运行时更改的窗体上很好

但相同的连接字符串在水晶报表中不起作用

i使用sql server 2008和vs c＃desktop应用程序我谷歌但没有罚款解决方案

That is my code working fine on my machine but not working on other machine.
New Connection String work Fine on windows form that i change at run time on Client machine
but same Connection String not work in crystal reports
i used sql server 2008 and vs 2012 c# desktop application i google but not fined the soluation

推荐答案

您已添加

You have added

Integrated Security=True"

并且还提供了用户名和密码，是出于任何目的还是只是你误将它放了？

阅读<目的是什么？ a href =https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.integratedsecurity(v=vs.110).aspx> IntegratedSecurity [ ^ ]

你好，



根据我的知识，客户端机器应该有Dot Net Version Framework 2.0或更高版本。在基于Windows的运行中需要使用Crystal报表设置。客户端计算机中有哪些操作系统？



希望你能谷歌吗？

Hello ,

As per my Knowledge,The Client machine should have Dot Net Version Framework 2.0 or above .Crystal Report Set Up is being needed to Run in windows based .Which Operating system is there in client machine?

Hope u can google it ?

这篇关于Crystal：无法在客户端计算机上打开Connection的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！