使用ASP.NET连接Crystal报表中的多个数据库 [英] Connect multiple database in crystal report using ASP.NET

问题描述

我有3个数据库连接到我的水晶报告，它正在我的水晶报告中工作。现在我想在ASP.Net中查看它，但它说数据库登录失败。



我尝试过：

I have 3 databases connected to my crystal report, it is working in my crystal report. Now I want to view it in ASP.Net but it says Database login failed.

What I have tried:

'FOR LOGIN CREDENTIALS
With crConnectionInfo
    .ServerName = server
    .DatabaseName = dbname
    .UserID = userid
    .Password = "pw
End With

With crConnectionInfo1
    .ServerName = server
    .DatabaseName = dbname
    .UserID = userid
    .Password = "pw
End With

With crConnectionInfo2
    .ServerName = server
    .DatabaseName = dbname
    .UserID = userid
    .Password = "pw
End With

CrTables = reportdoc.Database.Tables

Dim myTable1 As CrystalDecisions.CrystalReports.Engine.Table = CrTables(0)
Dim myTable2 As CrystalDecisions.CrystalReports.Engine.Table = CrTables(1)
Dim myTable3 As CrystalDecisions.CrystalReports.Engine.Table = CrTables(2)

Dim myTableLogonInfo As TableLogOnInfo = myTable1.LogOnInfo
Dim myTableLogonInfo1 As TableLogOnInfo = myTable2.LogOnInfo
Dim myTableLogonInfo2 As TableLogOnInfo = myTable3.LogOnInfo

crtableLogoninfo.ConnectionInfo = crConnectionInfo
myTable1.ApplyLogOnInfo(myTableLogonInfo)


crtableLogoninfo.ConnectionInfo = crConnectionInfo1
myTable2.ApplyLogOnInfo(myTableLogonInfo1)


crtableLogoninfo.ConnectionInfo = crConnectionInfo2
myTable3.ApplyLogOnInfo(myTableLogonInfo2)

但这仍然抛出数据库登录失败。

but this still throw database login failed.

推荐答案

阅读您的代码：

Read through your code:

Dim myTableLogonInfo As TableLogOnInfo = myTable1.LogOnInfo
crtableLogoninfo.ConnectionInfo = crConnectionInfo
myTable1.ApplyLogOnInfo(myTableLogonInfo)

1. 获取 myTable1.LogOnInfo ，并将其存储在 myTableLogon中信息;
2. 更改完全不相关的变量 crtableLogoninfo ;
3. 将未更改的登录信息从 myTableLogonInfo 应用到 myTable1 ;

1. Get myTable1.LogOnInfo, and store it in myTableLogonInfo;
2. Change the completely unrelated variable crtableLogoninfo;
3. Apply the unchanged logon info from myTableLogonInfo to myTable1;

据推测，启动 crtableLogoninfo.ConnectionInfo = ... 的三行应引用 myTableLogonInfo ... 变量。

Presumably, the three lines that start crtableLogoninfo.ConnectionInfo = ... should be referencing the myTableLogonInfo... variables instead.

Dim myTableLogonInfo As TableLogOnInfo = myTable1.LogOnInfo
myTableLogonInfo.ConnectionInfo = crConnectionInfo
myTable1.ApplyLogOnInfo(myTableLogonInfo)

这篇关于使用ASP.NET连接Crystal报表中的多个数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！