Stephen,
Yes, always a gotcha somewhere. I will code around it but starting a new
process instead of thread.
I didn't notice this caveat in the 2.99 documentation. When you get around to
2.100 :{) could you add this warning?
Thank you for responding quickly. Your hard work is appreciated.
Bob
-----Original Message-----
From: Steffen Goeldner [mailto:sgoeld...@cpan.org]
Sent: Thursday, April 14, 2011 10:39 AM
To: Robert Boisvert
Cc: dbi-users@perl.org
Subject: Re: DBD::ADO Crashes on Fork
Robert Boisvert wrote:
> I'm working on a project to connect to a SQLExpress database on a Win7x64
> computer and running into a problem when I fork to a child process. I know
> that it is important to close file handles when forking but I can't seem to
> close the ADO handles and the program crashes when the child process
> terminates (see program snippet below). Is my code in error or is there
> something amiss with the ADO/DBI drivers?
DBD::ADO uses Win32::OLE, and the ActiveState people say:
... you definitely cannot use Win32::OLE in a program that uses
(pseudo-)fork.
<http://www.nntp.perl.org/group/perl.par/2007/01/msg2802.html>
Steffen
P.S.: Sorry for the long delay. Our spam filter complained about
the MS office content. Look here what happens:
<http://www.nntp.perl.org/group/perl.dbi.users/2011/04/msg35763.html>
