Hi I'm having a big headache cause of a problem with Crystal Reports 9.
I built a VB.NET application based on an Access DB that generates reports to be printed.
All of the reports work fine except one that gives the following error:

Error in File C:\DOCUME~1\lorenzo\IMPOST~1\Temp\temp_a1429177-ff7b-4b26-b3f9-710cefe75ee2.rpt:
Query Engine Error

Now, the report is based on a dataset wich is based onto a .xsd schema. The dataset contains several tables linked in the .xsd schema. The dataset is filled in the form and then the Report is called from the form. Code follows:

Dim DaAna As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM Anagrafica WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaQua As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM QuadroCli WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaRefDX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Refrazione WHERE id_cli = '" & UGuid.ToString & "' AND occhio_DX = True", oConn)
        Dim DaRefSX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Refrazione WHERE id_cli = '" & UGuid.ToString & "' AND occhio_DX = False", oConn)
        Dim DaCoc As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Condizioni_ocu WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaLenDX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Lenti WHERE id_cli = '" & UGuid.ToString & "' AND occhiodx = True ORDER BY data DESC", oConn)
        Dim DaLenSX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Lenti WHERE id_cli = '" & UGuid.ToString & "' AND occhiodx = False ORDER BY data DESC", oConn)
        Dim DaOcc As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Occhiali WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaFat As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 5 * FROM Fatture WHERE id_cli = '" & UGuid.ToString & "' ORDER BY data DESC, n_fat DESC", oConn)

        oConn.Open()
        DaAna.Fill(oDsStampaQuadroCli, "Anagrafica")
        DaQua.Fill(oDsStampaQuadroCli, "QuadroCli")
        DaRefDX.Fill(oDsStampaQuadroCli, "Refrazione_od")
        DaRefSX.Fill(oDsStampaQuadroCli, "Refrazione_os")
        DaCoc.Fill(oDsStampaQuadroCli, "Condizioni_ocu")
        DaLenDX.Fill(oDsStampaQuadroCli, "Lenti_od")
        DaLenSX.Fill(oDsStampaQuadroCli, "Lenti_os")
        DaOcc.Fill(oDsStampaQuadroCli, "Occhiali")
        DaFat.Fill(oDsStampaQuadroCli, "Fatture")
        oConn.Close()

        Dim Rpt As New StampaQuadroCli
        Rpt.SetDataSource(oDsStampaQuadroCli)
        CRV.ReportSource = Rpt

The point is that IT HAS ALWAYS WORKED !!! I cannot understand why now it has gone nuts.
The report contains sub reports based on tables wich are not linked to other tables in the report. I select datas filling them with different queryes.
This progect was compiled about 6 months ago and since then I haven't touched it. Now I started back working on it and I got busted before starting cause of this problem.
I saw around that many suggest to look at a document called "c2011164.asp", but it is not any more avvlible in its location.
I already updated Crystal reports to Service Pack 3, but nothing has changed.

Please suggest something, I'm really running out of ideas.

Thanks

                           Verdun

Hi I am facing the same problem.. How did you resolve this.. Please help me..

And me too.
I use dataset to fill the report. And I get below;
Error in File C:\WINDOWS\TEMP\{00D38B30-AE4C-447F-9008-6E33A9392EE3}.rpt: Invalid Query Engine property.

Who can help us?

In your report Remove Selected Datasbase Fields & Readd them to the report, that will reset it for you, its tedious but it works.

The reports really can be shown at windows 2000 or windows xp server.
But when install it to windows 2003, it incurs such error.

Err Msg: "Query Engine error..." when running a .NET app on a client computer
The information in the article refers to:
Crystal Reports for Visual Studio .NET

Applies to:

Reported version only
Deployment
Runtime Files
ADO.NET

Synopsis

An application uses Crystal Reports for Visual Studio .NET 2002 or 2003 (not Crystal Reports 9 or 10) as the reporting development tool to report off an ADO.NET dataset.

This application runs successfully on the development computer, but when you deploy this application to a client computer, the following error message appears:

"Query Engine error in C:\Temp\YourReport.rpt"

Why does this error message appear and how do you resolve it?

Solution

The error message appears because the runtime files for the ADO.NET dataset are missing from the application setup.

To resolve this error message:

1.Include the following merge modules in the setup project:

• VC_CRT.msm

• VC_STL.msm

You can find these merge modules in the C:\Program Files\Common Files\Merge Modules folder.

2. Ensure that the following files are located in the System32 folder on the client computer, depending on the version of Visual Studio .NET:

• Visual Studio .NET 2002 - Msvcr70.dll and Msvcp70.dll

• Visual Studio .NET 2003 - Msvcr71.dll and Msvcp71.dll


Additional Information
---------------------

For further information on deploying a .NET application, search for crnet_deployment.pdf on our support site:

http://support.businessobjects.com/search

Thanks for demon090977 and wzwar.
I found my error is "Query Engine property. " not "Query Engine error...".
I tried every possible method. But failed.
It drived me crazy.
Acturely the report can be viewed in the LAN.
But can't be viewed through the internet.
Your help is appreciation.

Detail:
http://p2p.wrox.com/topic.asp?TOPIC_ID=26173