Crystal Report数据库登录错误..... [英] Crystal Report DataBase Logon Error.....

问题描述

我创建了一个水晶报告，显示来自两个表格的数据（MSAccess）....

当我在我的电脑上运行表格时它很好并显示记录..当我运行它时在其他PC上出现数据库登录对话框。它需要登录ID和密码，但我没有在数据库中提供任何密码...如果我点击完成按钮，则显示登录失败。请再试一次。

我的C＃代码是 - ：

I create a crystal report, which show data from two tables(MSAccess)....
When i run the form in my PC its good and show the records.. when i run it on other PC the Database Login dialog box appear.Its want LoginID and password but I don''t give any password in the database... If I click finish button it shows Logon failed. Please Try again.
My C# code is -:

OleDbConnection con=new OleDbConnection("Provider=Microsoft.jet.oledb.4.0; data source="+Application.StartupPath+@"\DataInfo1.mdb;");           
            con.Open();
           OleDbDataAdapter da=new OleDbDataAdapter("SELECT * FROM salesitemdetails WHERE bill_no in(SELECT bill_no FROM salesdetails WHERE custid in( SELECT custid FROM custdetails where custarea='"+ this.textBox1.Text.Trim() +"' order by custid))",con);
           DataSet ds = new DataSet();
           da.Fill(ds);
           CrystalReport1 cr = new CrystalReport1();
           cr.SetDataSource(ds);
           cr.SetDatabaseLogon("Admin", "");
            this.crystalReportViewer1.ReportSource = new CrystalReport1();
            this.crystalReportViewer1.Show();

如何解决它？





每个帮助都会感谢....

How to fix it ??


Every Help will be Appreciate....

推荐答案

你可以参考这个URL：

示例代码



请使用此连接字符串：Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C：\\ \\ _dydatabase.mdb;用户ID = admin;密码=;

You can refer to this URL:
Sample code

Please use this connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

这篇关于Crystal Report数据库登录错误.....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！