CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    3

    Unhappy 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.

  2. #2
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    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
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  3. #3
    Join Date
    Jun 2004
    Location
    Kashmir, India
    Posts
    6,808

    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.

  4. #4
    Join Date
    Jul 2009
    Posts
    3

    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.

  5. #5
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Query engine error when change database

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

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

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
  •  





Click Here to Expand Forum to Full Width

Featured