----- Forwarded message from "Samuel Zheng - keunghing.com" <samuel_zheng [at] keunghing.com> -----

From: "Samuel Zheng - keunghing.com" <samuel_zheng [at] keunghing.com>
To: Tim.Bunce [at] pobox.com
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 -----

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" <Tim.Bunce [at] pobox.com>
To: <dbi-users [at] perl.org>
Cc: <samuel_zheng [at] keunghing.com>
Sent: Sunday, July 15, 2007 5:24 PM
Subject: (Fwd) dbi help


> ----- Forwarded message from "Samuel Zheng - keunghing.com"
> <samuel_zheng [at] keunghing.com> -----
>
> From: "Samuel Zheng - keunghing.com" <samuel_zheng [at] keunghing.com>
> To: Tim.Bunce [at] pobox.com
> 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
>
>