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.
