Query engine error when change database

Hi.

I have an error to go mad. My vb.net application makes a report that runs fine in my local machine (with vs2003 and SQL Express 2005). My problem occurs when I execute this using an external database (SQL-Server 2000). Then my app returns the error "Query engine error: "c:....".
The actually data origin for report is a dataset, and I've compared the two datasets filled with each databases, and the content and structure for both is the same.

I don't know what more to look. Any suggestion is well come.

Thanks is advance.

Try to execute the query from SQL 2000, to see if it's a compatibility problem, or a connection string issue

If you are using Crystal Reports ( which I assume that you are), then you need to see Crystal Report documentation. Also check whether the database on your system and the one that is on the client system have same schema. There can be hundred different reasons why this is happening. You will need to find more specific information abou the exception and see where exactly it is happening.

Thanks, but I think here is a mistake.

My problem isn't that the dataset don't give me anything from the SQL-Server 2000. Really both datasets have the same structure and data values. The problem occur when I attempt to apply this to report then I obtain the error. Unfortunately I'm not be able to say you anymore as the system continue executing the process without any more info. I've attempted to find something more debugging it, but I obtain nothing more.

The mystery is still on. Thanks again.

You haven't posted any code. Show your connection string, and report parameters