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_CoparnEmptyAfterDate.SelectCommand.Para meters("@Date").Value =
DateTimePicker1.Value

Adapter_Sp_CoparnEmptyAfterDate.Fill(DataSet_Sp_Co parnEmptyAfterDate)
'This works fine, because the next message box returns the number of
rows.
MsgBox(DataSet_Sp_CoparnEmptyAfterDate.Tables(0).R ows.Count())

'I have a crystal report predefined and based on the same dataset
Dim oRpt As New CrystalReport1
oRpt.Load()
oRpt.SetDataSource(DataSet_Sp_CoparnEmptyAfterDate )

'So far so good, but now ...
CrystalReportViewer1.ReportSource = 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**********@telenet.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_CoparnEmptyAfterDate.SelectCommand.Para meters("@Date").Value =
DateTimePicker1.Value

Adapter_Sp_CoparnEmptyAfterDate.Fill(DataSet_Sp_Co parnEmptyAfterDate)
'This works fine, because the next message box returns the number of
rows.
MsgBox(DataSet_Sp_CoparnEmptyAfterDate.Tables(0).R ows.Count())

'I have a crystal report predefined and based on the same dataset
Dim oRpt As New CrystalReport1
oRpt.Load()
oRpt.SetDataSource(DataSet_Sp_CoparnEmptyAfterDate )

'So far so good, but now ...
CrystalReportViewer1.ReportSource = 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