Martin from easysoft has pointed me to the right direction and have the
issue resolved. Thanks the dbi and odbc. They made Perl so much more
powerful!
----- Original Message -----
From: "Tim Bunce" <[EMAIL PROTECTED]>
To: <[email protected]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 15, 2007 5:24 PM
Subject: (Fwd) dbi help
----- Forwarded message from "Samuel Zheng - keunghing.com"
<[EMAIL PROTECTED]> -----
From: "Samuel Zheng - keunghing.com" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: dbi help
Date: Sun, 8 Jul 2007 17:22:04 -0400
X-Pobox-Antispam: country/hongkong returned deny
Hi Tim,
I was looking for a solution on the internet when I came across your name
. so I decided to drop your a line and hopefully
you can point me to right direction.
I am using WindowsXP and IIS is running. ActivePerl 5.8.8 build 817 is
installed, dbd-odbc 1.13 is also installed. The problem I have is it fails
to open an access97 database, I used odbcad32.exe to define a DSN, I put
in
the user as admin and its password accordingly and it can be opened by my
crystal report writer.
The problem was not there before. I can developed many different pages in
Perl before it stopped working. and I don't know why it stopped. I have
exhausted
everything I can do (inclding reinstall perl) but no avail. Hope you can
give me a hint . Thank you in advance. The following is the line it
failed:
$dbh = DBI->connect($dsn,$user,$pswrd,$driver,{RaiseError=>1}) or die
"Database connection not made: $DBI::errstr";
the error is:
DBI connect('btn','',...) failed: [Microsoft][ODBC Microsoft Access
Driver]
Disk or network error. (SQL-HY000)(DBD: db_login/SQLConnect err=-1) at
C:\ButtonS\khoffice\pwschedule.pl line 43
Samuel Zheng
----- End forwarded message -----
__________ NOD32 2399 (20070714) Information __________
This message was checked by NOD32 antivirus system.
http://www.nod32.com.hk
