Query Engine Error ...

[Premalm]

Hi Guys,

This code is giving me headaches. I am getting a Query Engine Error which I run this code on my development machine. I have VS 2003 and CR for .Net. I have Msvcr71.dll and Msvcp71.dll in the system folder and the msm files in mergemodules folder. Any Ideas ?

Dim oRpt As New CrystalReport1
Dim sRptSQL As String = "Select * from PII.CAL_NAMES"
Dim oOleDbConnection As New OleDbConnection("Provider=MSDAORA;Data Source=PIID;User ID=<id>;Password=<passwd>")
oOleDbConnection.Open()
Dim oOleDbData As New OleDbDataAdapter(sRptSQL, oOleDbConnection)
Dim ds As New Dataset1
oOleDbData.Fill(ds, "CAL_NAMES")

oRpt.Database.Tables(0).SetDataSource(ds)
CrystalReportViewer1.ReportSource = oRpt
CrystalReportViewer1.DataBind()

Thanks
Premal