MS Access Database Connection String
Posted on 2006-11-21
Help! I'm using some code for a ReportDocument object that's connecting to an SQL database. I need the connection object to point to an Access database. Can someone please tell me how to modify this code to do this? There is not a username or password on the access database, I just need the database info.
Private Sub ConfigureCrystalReports()
AccessTest = New ReportDocument()
Dim reportPath As String = Server.MapPath("Reports/AccessTest.rpt")
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo()
'This is the SQL Server connection data that I need to change to an Access connection:
myConnectionInfo.ServerName = "MyServer"
myConnectionInfo.DatabaseName = "DatabaseName"
myConnectionInfo.UserID = "TestUser"
myConnectionInfo.Password = "TestPassword"
myCrystalReportViewer.ReportSource = AccessTest
THis is extremely urgent - any resolution will be greatly appreciated!