On Mon, Nov 08, 2004 at 03:45:27PM -0500, Oliver Klozoff wrote: > > From: David Davis [mailto:[EMAIL PROTECTED] > > Sent: Monday, November 08, 2004 2:47 PM > > To: Oliver Klozoff > > Subject: Re: POE + database access > > > > We would have no idea what your problem is without showing us > > any code. > > > > My reflex reason would be that you are using MSSQL :) > > > > That doesn't make much sense, as MSSQL is running on the database machine, > while the program runs on the little Linux box under my desk ;)
I think the problem's in FreeTDS. I've seen similar behaviour in non-POE apps using it. I'd suggest you implement some sort of health-check that restarts the program if it locks. Also consider using one of the DBI PoCos to put the DBI connection in a separate process that can be monitored from the main POE run loop. -- Bring me my etherkiller; Oh clouds unfold! / Bring me the magic smoke of desire I shall not cease from mental fight / Nor shall my LART rest in my hand Till we have buried the bodies / Of all the lusers in all this land -- rpg, ASR [ My homepage is http://www.trout.me.uk/ ]