in reply to 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 +l +ine 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;
perhaps someone could email me? ryan@lonegamers.com what do i do?