Jochem maintain connection: What a good idea - didn't occur to me. I'll try it.
Thanks Richard > -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: 05 June 2008 13:40 > To: CF-Talk > Subject: Re: Annoying SequeLink JDBC Driver failure > > Richard Meredith-Hardy wrote: > > I have a CF8 app which gets updates from an ancient ODBC > datasource at > > 15 min intervals. Generally it works fine, but once or > twice a week > > it gets the error: > > > > Error Type: Database > > Message: Error Executing Database Query. > > Detail: [Macromedia][SequeLink JDBC Driver][ODBC > > Socket][TSODBC]FrameRead:NetRead header > > Looks like this error is actually in the ODBC network driver. > > > > And it seems at least a CF8 service restart and sometimes a > complete > > server reboot is the only thing which will fix it. > > > > Has anyone any ideas how to reset the SequeLink JDBC Driver > in a more > > graceful fashion? Preferably automatically.... > > Since the ODBC network driver is loaded in the ODBC Server > process I would expect a restart of the ODBC Service to fix > any problems between the ODBC Service and the remote > database. Just uncheck the maintain connection checkbox for > the connection between CF and the ODBC Service to make sure > that connection gets reset every time (I don't think that > will have significant performance impact compared to talking > to a remote database). > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
