水晶报表联接Oracle8.05问题
大聪 2003-08-11 09:18:29 当我用dataset1.xsd数据集时就不能正确登陆oracle数据库,
直接联接就可以在水晶报表里浏览数据.
有谁什么dataset1.xsd数据集建立时要注意什么吗?有什么特殊的要求吗?
以下是我的代码:
Public oRpt As New ReportDocument()
Dim conn As OleDbConnection = New OleDbConnection(ConfigurationSettings.AppSettings("ora_connectionString"))
Dim adapter As OleDbDataAdapter
Dim ds As Dataset1 = New Dataset1()
Dim logOnInfo As TableLogOnInfo = New TableLogOnInfo()
oRpt.Load(Server.MapPath("CrystalReport1.rpt"))
logOnInfo.ConnectionInfo.ServerName = "zcgl"
'logOnInfo.ConnectionInfo.DatabaseName = "zcgl"
logOnInfo.ConnectionInfo.UserID = "zc_gly"
logOnInfo.ConnectionInfo.Password = "pwd_zc_gly"
oRpt.Database.Tables(0).ApplyLogOnInfo(logOnInfo)
CrystalReportViewer1.ReportSource = oRpt
提示"登陆失败",
如果CrystalReport1.rpt不用Dataset1数据集,直接连数据库就可以