I can recall something similar, though don't remember what is it exactly I
did at that time.
1. You can/should try to reinstall perl, since the error seems to be coming
from the perl interpreter.
2. If I can recall correctly there was a problem with no explicitelly
undef'ing handles, that caused my problem. Have you tried to disconnect()
and then maybe even undef the db handle?
Ilya
-----Original Message-----
From: Richard Chiswell
To: [EMAIL PROTECTED]
Sent: 10/16/01 4:26 PM
Subject: Problem with DBI::trace on MSWin32
I've got the following script which has a 100% failure
rate when trying to run it on:
Windows 2000 Professional (Service Pack 2)
ActiveState Perl v5.6.1 MSWin32-x86-multi-thread build 629
DBI 1.14 (and DBI 1.20)
DBD::ODBC 0.28 to MS Access Driver (*.mdb 4.00.6019.00)
I enabled the DBI tracing to try and track down another
problem I was encountering, but every time the script runs
it produces a:
Program Error
Perl.exe has generated errors and will be closed by Windows.
You will need to restart the program. An error log is
being created
which is exactly the same 'warning' as I get when the
fault I'm trying to track down occurs. Can somebody please
assist me as to what is going wrong with the trace and
what could be going wrong in my main script...
Many thanks,
Richy.
======== 100% failure script follows
======== comment out the DBI->trace line to make it work
#!perl.exe
use DBI;
DBI->trace(5,"c:/dbilog.txt");
$database_itcentral=DBI->connect("dbi:ODBC:it_central",
"","",{RaiseError=>1,PrintError=>1,AutoCommit=>1}) || die ("Bad
DB!".$DBI::errstr."\n");
$database_itcentral->{LongReadLen} = 512 * 1024;
print "Done\n";
=========================================================
======== Results of dbi.log after above script run
=========================================================
DBI 1.14-nothread dispatch trace level set to 5
Note: perl is running without the recommended perl -w option
-> DBI->connect(dbi:ODBC:it_central, , ****, HASH(0x1a8f064))
-> DBI->install_driver(ODBC) for perl=5.006001 pid=1804 ruid=0
euid=0
install_driver: DBD::ODBC loaded (version 0.28)
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x1bb9708)=>DBI::dr=HASH(0x1cfe324),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, DBD::ODBC::dr, 92)
dbih_setup_attrib(DBI::dr=HASH(0x1cfe324), Err, Null!)
SCALAR(0x1b8ace0)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x1cfe324), State, Null!)
SCALAR(0x1b8bdc0) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x1cfe324), Errstr, Null!)
SCALAR(0x1b8bd9c) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x1cfe324), Handlers, Null!)
ARRAY(0x1cffbbc) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x1cfe324), Debug, Null!) 0 (already
defined)
<- install_driver= DBI::dr=HASH(0x1bb9708)
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x1bb9708)~0x1cfe324
'it_central' '' **** HASH(0x1a854bc))
[speaking personally]
--
Richard Chiswell, Systems Developer.
Cradley Print Group.
All opinions and comments expressed are NOT necessarily
those of Cradley Print.
--
The information contained within this e-mail sent by Cradley Print Ltd.
is
confidential and is intended for the named recipient only. If you are
not
the intended recipient please notify us by telephone immediately on
01384
414100 (UK)or +(44)1384 414100 (International) or return it to us by
e-mail
quoting the name of the sender and the addressee. Please then delete it
from
your system.
Encryption and Viruses
==================
Please note that this e-mail and any attachments have not been
encrypted.
They may therefore be liable to be compromised. Please also note that it
is
your responsibility to scan this e-mail and any attachments for viruses.
Viruses and compromises of security are inherent risks in relation to
e-mail.
We do not, to the extent permitted by law, accept any liability (whether
in
contract, negligence or otherwise) for any virus infection and/or
external
compromise of security and/or confidentiality in relation to
transmissions
sent by e-mail.
Contracts
========
Please note, that contracts may NOT be concluded on behalf of Cradley
Print
Ltd by e-mail, but contracts on behalf of our clients may be concluded
by
e-mail.
