in reply to Re: Trouble with accessing MS Access database via Perl on web host........
in thread Trouble with accessing MS Access database via Perl on web host........

Reply to myself :)
Might as well add this, what to do after you connect...
my $sth = $dbh->prepare("SELECT email, password FROM surya"); $sth->execute; my $aref = $sth->fetchall_arrayref; $sth->finish; print "Email\tPassword\n"; for my $row (@$aref) { print join("\t",@$row) . "\n"; }
That would seem to emulate the rest of the functionality of your code except it doesn't output in HTML, have a look at something like HTML::Template for that.
  • Comment on Re: Re: Trouble with accessing MS Access database via Perl on web host........
  • Download Code

Replies are listed 'Best First'.
Re: Re: Re: Trouble with accessing MS Access database via Perl on web host........
by Anonymous Monk on Jul 24, 2002 at 09:15 UTC
    To Whom It May Concern. I have tried to use Perl DBI and MS Access together for 2 weeks. But even though I programmed the same code as the code is shown above, it keep telling error message: CGI Error The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: DBI->connect(driver={Microsoft Access Driver (*.mdb)};DBQ=2000ticket) failed: MicrosoftODBC Driver Manager Invalid string or buffer length (SQL-S1090)(DBD: db_login/SQLConnect err=-1) at d:\inetpub\scripts\find_ticket_test.pl line 19 I really do not know what to do. Please answer my question. thank you