Query Engine Error makes me think there's a problem with the ODBC driver, but it sounds like this report was working at one point. If the report was working, and stopped working after you made a change, my question would be what exactly did you change? If its the select criteria, cut and paste it so we can see if there's something wrong with the syntax.
Does this report have a subreport? Is the subreport dependent on anything you've changed in the main? Melissa Reed <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 04/23/2007 10:27 AM Please respond to [email protected] To [email protected] cc Subject Error in Crystal Report on form HPD:HelpDesk_SLA When I try to qualify my report on Arrival Time, I'm getting an error when I run the report through the client tool (ver 6.3 patch20) or through Crystal (ver 9). The reports hangs for several minutes and finally returns the error. Tool Error - Query Engine Error Crystal Error - Query Engine Error: '42S:Driver]Cannot open catalog; Message number = 94. SERVER NAME' (SERVER NAME = our production server name) Any clues? If I don't qualify on that field, the report runs fine. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

