I've had it running on perl build 509, 628 and 633. All seem to need the extra buffer between 20480 and 30720. Contrary to my best guess, the Page Timeout also needs to be set between 300 and 400.
I'm using DBD:ODBC both an old version (contemporary with build 509) and the latest (from earlier this week).
My script has more than one thread open and may not be the most efficient code but, now I've increased the buffers/timeout, it works reasonably efficiently. There has never been a problem with Win NT, but it has never liked complicated configurations on Win 98 and 2000. The configuration is stored in lookup tables so the same script can either be extremely simple or very complicated.
Ian
At 13:32 31/10/2002 -0500, you wrote:
Ian, It would be good to know which driver(s) you use to clarify which need this setting.Thanks, Jeff > -----Original Message----- > From: Ian Summers [mailto:ian@;isdata.co.uk] > Sent: Thursday, October 31, 2002 11:24 AM > To: [EMAIL PROTECTED] > Subject: Solution to perl falling over randomly on Windows ODBC > > > Hi > > I have been searching for the solution to perl falling over randomly for > two or three years. By increasing the buffer size to 15 times the default > (to 30720) it now behaves correctly. The value chosen may need to vary > according to the complexity of the application. I also changed the Page > Timeout but I don't think that that is relevant. > > How to make this change: Control Panel>Administrative Tools>Data Source > (ODBC)>System DSN>Add/Configure (differs on early versions of Windows) > > Press the Options button and modify the Buffer Size. > > If you find this useful or have any comment to make please contact me > directly as well as the list as I no longer subscribe. That would be most > kind - thank you. > > Ian
