DBD:ODBC hangs when inserting/updating lots of rows

2003-10-07 Thread Stefan . Skopnik
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

Re: DBD:ODBC hangs when inserting/updating lots of rows

2003-10-07 Thread Scott Dial
I've had similar problems with Python inserting into Oracle. Turns out that Microsoft had a problem with MDAC on NT, and I had to upgrade to MDAC 2.5+ to get it to work. We were experiencing delays of up to 90 seconds on a simple select statement, and via sqlplus oracle would return the data in