在客户端计算机中生成水晶报表时会发生数据库登录对话框 [英] Database login dialog occurs when a crystal report generated in client machine

问题描述

大家好，

我已针对同一问题发布了一个问题（问题链接）。但尚未解决。

使用MS access 2007，VS 2010和VB.Net开发应用程序。在开发机器方面做得很好。在客户端计算机上安装也很有效。当我的应用程序开始生成报告时，它会弹出数据库登录窗口。如何解决这个问题？



实际上弹出报告处理2个表来生成。

单个表工作正常的报告。 />


弹出请求：

1.服务器名称：显示我的开发机器数据库位置

2.数据库名称：空

3.用户名：Admin

4.密码：空



我试过

  Dim  crtableLogoninfos  As  新 TableLogOnInfos（）
  Dim  crtableLogoninfo 作为 新 TableLogOnInfo（）
  Dim  crConnectionInfo  As  新 ConnectionInfo（）
  Dim  CrTables 作为表
  Dim  CrTable  As 表
  '  Dim crReportDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument  
 使用 crConnectionInfo 
 .DatabaseName = Application.StartupPath&   \sdcartdb.mdb 
 .Password =   
 结束 使用 
 CrTables = Report.Database.Tables 
 对于 每个 CrTable 在 CrTables 
 crtableLogoninfo = CrTable.LogOnInfo 
 crtableLogoninfo.ConnectionInfo = crConnectionInfo 
 CrTable.ApplyLogOnInfo（crtableLogoninfo）
 下一步 
 

仍然弹出。

我试过

view.SetDatabaseLogon（用户，pwd）

没希望。

有人可以帮我解决这个问题吗？

解决方案

< blockquote>在客户端设置ODBC SETTING机器。

仍然弹出exsisit在客户端机器上安装水晶运行时版本。



希望它能解决你的问题。

我使用了以下代码，

 Report.DataSourceConnections.Clear（）
 Report.DataSourceConnections.Item（ 0 ）。SetConnection（Application.StartupPath&   \db.mdb，  db.mdb， 1 ）

并解决了...谢谢..

我的解决方案是安装SQL Server  2012 客户端工具连接和后向客户端连接组件使用 SQL Server安装源。

Hello everyone,
I posted already one question for the same issue(Question link). But yet to solution.
Am using MS access 2007, VS 2010 and VB.Net to develop application. Worked well in developing machine. Installing in client machine also works well. When my application started to generate report it popups the database login window. How to solve this?

Actually popup occurs for report which handles 2 tables to generate.
Reports with single table working properly.

Pop up asks for:
1.Server name : Shows My developing machine database location
2. Database name : Empty
3. User name : Admin
4. Password : Empty

And i tried

Dim crtableLogoninfos As New TableLogOnInfos()
Dim crtableLogoninfo As New TableLogOnInfo()
Dim crConnectionInfo As New ConnectionInfo()
Dim CrTables As Tables
Dim CrTable As Table
'Dim crReportDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument
With crConnectionInfo
    .DatabaseName = Application.StartupPath & "\sdcartdb.mdb"
    .Password = ""
End With
CrTables = Report.Database.Tables
For Each CrTable In CrTables
    crtableLogoninfo = CrTable.LogOnInfo
    crtableLogoninfo.ConnectionInfo = crConnectionInfo
    CrTable.ApplyLogOnInfo(crtableLogoninfo)
Next

Still popup occuring.
I tried
view.SetDatabaseLogon(user, pwd)
No hope.
Can anyone help me out of this?

解决方案

set ODBC SETTING in client machine.
still popup exsisit install crystal runtime version in client machine.

hope it will resolve y r issue.

I used the following code,

Report.DataSourceConnections.Clear()
Report.DataSourceConnections.Item(0).SetConnection(Application.StartupPath & "\db.mdb", "db.mdb", 1)

And solved... Thanks..

my solution was by installing SQL Server 2012 Client Tool Connectivity, and backward client connectivity components using SQL Server setup source.

这篇关于在客户端计算机中生成水晶报表时会发生数据库登录对话框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！