error: requires explicit package name useing DBI

From: Andy Stevenson (no_at_chance.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 01:57:26 +0100

Hi,

I can't find the answer to this one, I'm trying to access an MS access
database from a web page.

I'm following the article at :
http://www.databasejournal.com/features/msaccess/article.php/10895_1408481_1
and I've got stuck trying to run the cgi script. I get this result.

Global symbol "$dbh" requires explicit package name at
c:\INDIGO~1\cgi-bin\access.cgi line 10.
Global symbol "$sqlstatement" requires explicit package name at
c:\INDIGO~1\cgi-bin\access.cgi line 13.
Global symbol "$sth" requires explicit package name at
c:\INDIGO~1\cgi-bin\access.cgi line 14.
Global symbol "$dbh" requires explicit package name at
c:\INDIGO~1\cgi-bin\access.cgi line 14.
Global symbol "$sqlstatement" requires explicit package name at
c:\INDIGO~1\cgi-bin\access.cgi line 14.
Global symbol "$sth" requires explicit package name at
c:\INDIGO~1\cgi-bin\access.cgi line 15.
Global symbol "@row" requires explicit package name at
c:\INDIGO~1\cgi-bin\access.cgi line 19.
Global symbol "$sth" requires explicit package name at
c:\INDIGO~1\cgi-bin\access.cgi line 19.
Global symbol "@row" requires explicit package name at
c:\INDIGO~1\cgi-bin\access.cgi line 20.
Execution of c:\INDIGO~1\cgi-bin\access.cgi aborted due to compilation
errors.

This would suggest it's a problem with the perl module, but this being my
first dabble with installing modules I'm not sure :)

The server is Win XP running Apache 1.2.26 & the GUI package manager tells
me I've got DBI-1.37 & DBD-ODBC-1.06 installed. I'm running other cgi
scripts ok, take a look: http://www.stevenson-central.no-ip.com/.

The access DB is sitting in a directory on the server & I've set ODBC as
outlined in the article.

Any suggestions greatly appreciated.

TIA.

Relevant Pages