Thanks, Jon. I'll try that and report back. -----Original Message----- From: Jon Frisby [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 3:06 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Zeos, MySQL problem
You can disable connection timeouts at the MySQL server level. You should check the docs to be sure, but I think the relevant variable is "wait_timeout" -- setting it to 0 should disable connection timeouts. -JF > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, December 15, 2003 12:28 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Zeos, MySQL problem > > > Good Afternoon! > > We're building an application with Delphi 7.0, the Zeos > controls and MySQL > v.4.0.15 which runs on a Red Hat 7.3 server. We are > experiencing a problem > where when a person lets the application sit for a while, we're losing > dataset connectivity that doesn't restore itself. I've been > studying the > documentation and I'm not finding any settings that would > stop the timeout > from happening. If anyone is aware of what to change, or > has experienced > the same problem, please let me know. > > BTW, I wasn't sure that this would be the place to post this sort of > question and would appreciate some guidance where I should go instead > if necessary. > > Thanks! > > David Christensen > Brokers International, Ltd. > 1200 E Main St > PO Box 160 > Panora, IA 50216 > (800) 362-1097 or (641) 755-2775 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > >
