Hi, wie got a very strange problem here on insertion/update of rows into an MS-ACCESS 97 DB which gives us a lot of headache.
The scripts simply hangs! It waits for an insert/update sent to the ODBC-Driver to succeed. But the operation never returns. No error code, nothing! The problem occurs sporadic, when a lot of the rows are manipulated fast in a close loop. The Scripts often hang after a few thousand rows have been manipulated successfully, but not always at the same position. On faster servers it occures more often than on slower ones. Strange, isn't it ?! We have an application doing inserts/updates/delete using a user frontend not showing this problem. So it seems to be related to some timing issues. I inserted a Win32::sleep(1) after the insert statement, and the problem disappeared! Well, not the best solution, though! We have some batch routines that should run at full speed. The problem doesn't seem to be related directly to DBD/DBI because we have an older script using Win32ODBC which shows the same problem. Well, it doesn't make sense to send a code example, becase it's rather trivial: Simply read lines from a large textfile, split, and do an insert into a table. Here our environment: Windows NT 4.0 SP6a ActiveState Perl 5.8.0 Build 805 DBD-ODBC 1.05 DBI 1.34 ODBC Driver : 4.00.5303.01 Is this a known issue? Thanks for any help Stefan Skopnik ----------------------------------------------------- Diese E-Mail der LBS an Sie wurde auch ueber fremde Computer weitergeleitet. Dabei ist die Gefahr durch Manipulation besonders gross. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vor- stehenden Erklaerungen und Aeusserungen ausschliessen. Die fuer die LBS gel- tenden Regeln ueber die Verbindlich- keit von Willenserklaerungen mit ver- pflichtendem Inhalt bleiben unberuehrt. ---------------------------------------------------
