I am trying to produce a report with an SQL string with a certain critea and then I get this error can anyone help how can I go ahead.The error is "Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified."
The code that produced the error.
Code:
Dim iSql As String = "select * from myQuery where ID =14"
Dim Conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Recordsets\Recordset\Recordset\bin\Debug\MyDB.accdb")
Dim dt As DataTable = New DataTable
Dim da As New OleDbDataAdapter(iSql, Conn)
da.Fill(dt)
myReport.SetDataSource(dt)
CrystalReportViewer2.ReportSource = myReport
CrystalReportViewer2.Refresh()
The error message says it can't find a file. Have you checked if the file is in the location that the program is looking for it. Is this program running on the same machine that you developed it on? Or, have you installed this app on another machine?