DBI-Help

Hi DBI Guru,

I am hoping someone will 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

The script worked before but not now. I don't know why. Definitely
something happened to my computer but I don't know what. please help. I
disable the firewall, I shared the foler, I recreated the DSN and I
reinstalled everything but no use. What else should I tried?

Samuel Zheng

Re: DBI-Help

Look like someone changed the access DB itself. If memory serves me corect
there are setting in Access that can prohibit remote usage.
I would try creating a new Access DB just to test to see if you can connect
with it.

Also you may have to do some configuration with IIS to get it to server up
perl pages. I know you have to load a .dll of some sort an with the latest
version if IIS thre are somve fancy controls thay you might have to set up
first to get perl pages served up.


----- Original Message -----
From: "Samuel Zheng - keunghing.com"
To:
Sent: Monday, July 09, 2007 5:46 AM
Subject: DBI-Help


> Hi DBI Guru,
>
> I am hoping someone will 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
>
> The script worked before but not now. I don't know why. Definitely
> something happened to my computer but I don't know what. please help. I
> disable the firewall, I shared the foler, I recreated the DSN and I
> reinstalled everything but no use. What else should I tried?
>
> Samuel Zheng
>
>

Re: DBI-Help

Samuel Zheng - keunghing.com wrote:
> Hi DBI Guru,
>
> I am hoping someone will 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
>
> The script worked before but not now. I don't know why. Definitely
> something happened to my computer but I don't know what. please help. I
> disable the firewall, I shared the foler, I recreated the DSN and I
> reinstalled everything but no use. What else should I tried?
>
> Samuel Zheng
>
>
A quick google search produced the following link that looks promising:

http://support.microsoft.com/default.aspx/kb/251254

Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com