Re: Unresponsive requests - very strange

>Enable query tracing (ODBC Control Panel) and get a log of the >actual query being send to the database. Then scrutinize that for >issues in the date pattern: 04/30/04 vs 05/01/04 vs 04/05/01 etc. > >Jochem Thanks for the tip. I'll give it a shot. Since my first message I have split out the fi

Re: Unresponsive requests - very strange

Earl, George wrote: > > Any thoughts on what might be causing this problem ONLY on the production > server and ONLY with dates starting on May 1? Where would you look next to > try to find the source of this problem? Enable query tracing (ODBC Control Panel) and get a log of the actual query bei

Re: Unresponsive requests - very strange

Employing Ockham's Razor here.. Are you sure that the app on production is submitting the right date when the user selects "May 1st, 2004" ?? Brian   From: Earl, George   To: CF-Talk   Sent: Monday, June 21, 2004 8:31 AM   Subject: Unresponsive requests - very strange

Unresponsive requests - very strange

I have a very strange and frustrating problem - We are running CF 5.0 on Windows 2000, Oracle 8i, and the Merant ODBC drivers that ship with CF (we have had problems with the Oracle native drivers). We have a reporting application that submits requests with 5 queries to Oracle and then massages