DBD-DB2 help

I installed Perl 5.8 and with PPM installed DBI and ODBC. Being new to Perl I was happy how everything worked. Saving all my configuration steps I made a document detailing such for others to use. Upon reading my document someone installed 5.6 instead of 5.8 by mistake and used PPM to install DBD-D

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

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 .

RE: fork and die

Well Tielman, I think you are lucky that you don't have to catch the status of your children! Just one comment about: $SIG{CHLD} = 'IGNORE'; ## Children die unnoticed ... I don't know exactly what your child does but if your child starts another process again, you might run in trouble. I code

DBD:ODBC hangs when inserting/updating lots of rows

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 spo

RE: fork and die

Thanks Jeroen, Somewhere in my quest to solve this issue, I read to first unset the child signal with $SIG{CHLD} = 'IGNORE'; ## Children die unnoticed ... and then in the child use setsid or die $!; which supposedly immediately dissociates the child from the mother, which means the mother doe

Re: fork and die

Read the docs, e.g., $dbh->{InactiveDestroy} Tim. On Tue, Oct 07, 2003 at 12:31:47PM +0100, tvilliers wrote: > Hi, > > I have a mother process which needs to fork off a child at every x > milestone. The child performs a small function (ie, write to a log) and > then dies. The general idea is tha

Re: How to Handle a oracle curser ones u get in the perl

On Tue, 7 Oct 2003 15:47:57 +0530 "Thutika, Srinivas (ODC - Satyam)" <[EMAIL PROTECTED]> wrote: > my requirement is as follows. > > 1) I have to call Oracle stored procedure. > > 2) The stored Procedure will return a curser. > > 3) My Question is that how to Handle this curser. What i mean is >

RE: fork and die

Hi Tielman, I had exactly the same problem (I asked about it about 2 weeks ago). I use Oracle though. Even if you don't use the handle from the mother in the child, the handle still gets fucked up. The child will try to close your handle. There is a modifier called InactiveDestroy, like: $db-

Re: fork and die

Thanks John, But the idea here is that the child doesn't need a handle at all -- I just want the mother's handle to be "left alone" ... Tielman On Tue, 07 Oct 2003 09:09:58 -0400, John Saylor wrote: > hi > > no- fork YOU and die ... > > ( 03.10.07 12:31 +0100 ) tvilliers: >> I have a mother

Re: fork and die

hi no- fork YOU and die ... ( 03.10.07 12:31 +0100 ) tvilliers: > I have a mother process which needs to fork off a child at every x > milestone. > Now, the mother has an open database handle, which from my understanding > gets transferred to the child at fork. I want the handle to stay with the

Re: Can perl convert an Access database to a Mysql one?

I believe you could use DBD::ODBC to access the "Access" database, and DBD::mysql to access the MySQL database, so here's what I'd do: * install the DBI module * install the DBD::ODBC module - then write a simple script to prove you can connect to the "Access" database * install

fork and die

Hi, I have a mother process which needs to fork off a child at every x milestone. The child performs a small function (ie, write to a log) and then dies. The general idea is that the mother is unaffected by any problems the child may encounter (ie, a closed socket, a full disk, eg). The child fork

RE: :Ingres 0.50 uploaded to CPAN - now with LONGs!

Have the random failures with prepared statements been fixed ? Cheers, Mark -Original Message- From: Henrik Tougaard [mailto:[EMAIL PROTECTED] Sent: 19 September 2003 12:27 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: DBD::Ingres 0.50 uploaded to CPAN - now

How to Handle a oracle curser ones u get in the perl

Hi friends, my requirement is as follows. 1) I have to call Oracle stored procedure. 2) The stored Procedure will return a curser. 3) My Question is that how to Handle this curser. What i mean is Curser is nothing but a result set which we are getting from the database. Pls let me know of pro

Can perl convert an Access database to a Mysql one?