vbnov
May 10th, 2006, 11:23 AM
Hi all,
The code I used is as follows.
dim dbconnection
as new oledb.oledbconnection(.....conn string...)
Dim SQL As String
SQL = "SELECT * FROM <TABLENAME> "
dbConnection.Open()
Dim objAdapter As New OleDb.OleDbDataAdapter(SQL, dbConnection)
Dim objDataSet As New DataSet
objAdapter.Fill(objDataSet)
Dim oReport As New CrystalDecisions.CrystalReports.Engine.ReportDocument
Dim sRptPath As String = Server.MapPath("CRlMT.rpt")
oReport.Load(sRptPath)
oReport.SetDataSource(objDataSet)
CrystalReportViewer1.ReportSource = oReport
when i ran it I got the following error.
Logon failed. Details: ADO Error Code: 0x Source: Provider Description: Authentication failed. Native Error: Error in File <path>.rpt: Unable to connect: incorrect log on parameters.
what I am doing wrong here. Help is greatly appreciated.
note: asp.net web app.
The code I used is as follows.
dim dbconnection
as new oledb.oledbconnection(.....conn string...)
Dim SQL As String
SQL = "SELECT * FROM <TABLENAME> "
dbConnection.Open()
Dim objAdapter As New OleDb.OleDbDataAdapter(SQL, dbConnection)
Dim objDataSet As New DataSet
objAdapter.Fill(objDataSet)
Dim oReport As New CrystalDecisions.CrystalReports.Engine.ReportDocument
Dim sRptPath As String = Server.MapPath("CRlMT.rpt")
oReport.Load(sRptPath)
oReport.SetDataSource(objDataSet)
CrystalReportViewer1.ReportSource = oReport
when i ran it I got the following error.
Logon failed. Details: ADO Error Code: 0x Source: Provider Description: Authentication failed. Native Error: Error in File <path>.rpt: Unable to connect: incorrect log on parameters.
what I am doing wrong here. Help is greatly appreciated.
note: asp.net web app.