Query engine error on crystal report based on stored procedure

[Frank Teunen]

Dear reader,

I'm having a problem linking a dataset to a crystal report.
I'm using next code. In between I explain my problem

'This code is to fill a dataset with the result of a stored
procedure on an SQL data base

Adapter_Sp_Copa rnEmptyAfterDat e.SelectCommand .Parameters("@D ate").Value =
DateTimePicker1 .Value

Adapter_Sp_Copa rnEmptyAfterDat e.Fill(DataSet_ Sp_CoparnEmptyA fterDate)
'This works fine, because the next message box returns the number of
rows.
MsgBox(DataSet_ Sp_CoparnEmptyA fterDate.Tables (0).Rows.Count( ))

'I have a crystal report predefined and based on the same dataset
Dim oRpt As New CrystalReport1
oRpt.Load()
oRpt.SetDataSou rce(DataSet_Sp_ CoparnEmptyAfte rDate)

'So far so good, but now ...
CrystalReportVi ewer1.ReportSou rce = oRpt

This code works perfectly on my PC where I develop: I see the result in the
viewer.
However on a deployment PC I receive error "Query engine error".
The user is exactly the same as on the development pc, so it is not a matter
of autorisation.

Any ideas ?

Thanks and kind regards
Frank

[Frank Teunen]

Found solution myself.

I had .net framework 2.0 installed on deployment pc and crystal reports
version from visual studio 2003 can only work with version 1.1
"Frank Teunen" <fr**********@t elenet.be> schreef in bericht
news:wn******** *************** @phobos.telenet-ops.be...
Dear reader,

I'm having a problem linking a dataset to a crystal report.
I'm using next code. In between I explain my problem

'This code is to fill a dataset with the result of a stored
procedure on an SQL data base

Adapter_Sp_Copa rnEmptyAfterDat e.SelectCommand .Parameters("@D ate").Value =
DateTimePicker1 .Value

Adapter_Sp_Copa rnEmptyAfterDat e.Fill(DataSet_ Sp_CoparnEmptyA fterDate)
'This works fine, because the next message box returns the number of
rows.
MsgBox(DataSet_ Sp_CoparnEmptyA fterDate.Tables (0).Rows.Count( ))

'I have a crystal report predefined and based on the same dataset
Dim oRpt As New CrystalReport1
oRpt.Load()
oRpt.SetDataSou rce(DataSet_Sp_ CoparnEmptyAfte rDate)

'So far so good, but now ...
CrystalReportVi ewer1.ReportSou rce = oRpt

This code works perfectly on my PC where I develop: I see the result in the
viewer.
However on a deployment PC I receive error "Query engine error".
The user is exactly the same as on the development pc, so it is not a matter
of autorisation.

Any ideas ?

Thanks and kind regards
Frank