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.Make sure the file exists at the application path. Also make sure if you have permission to access the databasesql
No comments:
Post a Comment