Skip to Content
0
Former Member
Jan 09, 2012 at 05:10 PM

Report won't connect to access database in asp.net

46 Views

I am having a problem with getting a report to run on a website when the report uses an access database.

I am running the website through the debugger in VS2010. The funny thing is that i can get it working through vb.net

and in asp.net it works fine if it is sql server.

The message i get is "The report you requested requires further information." and it gets stuck at that no matter what i enter.

The database does exist at that location and the database password is correct

here is the code i am using

Dim rept As ReportDocument

rept = New ReportDocument()

rept.Load("E:\Teams1.rpt")

CrystalReportViewer1.ReportSource = rept

For i = 0 To CrystalReportViewer1.LogOnInfo.Count - 1

CrystalReportViewer1.LogOnInfo(i).ConnectionInfo.ServerName = "E:\data.mdb"

CrystalReportViewer1.LogOnInfo(i).ConnectionInfo.DatabaseName = ""

CrystalReportViewer1.LogOnInfo(i).ConnectionInfo.Password = "x"

CrystalReportViewer1.LogOnInfo(i).ConnectionInfo.UserID = "Admin"

Next i

Anyone have any clue at what i am doing wrong?