-
July 29th, 2009, 05:48 AM
#1
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.
-
July 29th, 2009, 12:53 PM
#2
Re: Query engine error when change database
Try to execute the query from SQL 2000, to see if it's a compatibility problem, or a connection string issue
-
July 29th, 2009, 03:19 PM
#3
Re: Query engine error when change database
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.
-
July 30th, 2009, 02:50 AM
#4
Re: Query engine error when change database
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.
-
July 30th, 2009, 11:42 AM
#5
Re: Query engine error when change database
You haven't posted any code. Show your connection string, and report parameters
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|