in reply to Re: Re: Re: problems with ODBC...
in thread problems with ODBC...

well, ive modified my code slightly, and this is the error that im getting now
Can't locate object method "execute" via package "DBI::db" (perhaps yo +u forgot to load "DBI::db"?) at c:\foxserv\apache\cgi-bin\access2.pl +line 12.
and heres what my code looks like
#!C:/Perl/bin/perl.exe use CGI::Carp "fatalsToBrowser"; use CGI qw(:standard); use DBI; print header(); my $DSN = 'driver=Microsoft Access Driver (*.mdb);dbq=C:/FoxServ/Apach +e/cgi-bin/test.mdb'; my $dbh = DBI->connect("dbi:ODBC:$DSN", '','') or die "$DBI::errstr\n"; $dbh->execute(); @information = $dbh->fetchrow_array; foreach $test (@information){ print $test; print "\n<br>\n"; } $dbh->disconnect; $dbh->finish;
what do i do?

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: problems with ODBC...
by dws (Chancellor) on Jan 29, 2002 at 10:25 UTC
    what do i do?

    You dropped the line that prepares the query (and you renamed a variable). $dbh is holding a connection object, not a statement handle object. Your original example got this part right.