----- 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 -----
