This looks a lot like CGI ERROR RELATING TO MYSQL.
Again the questions: Why do you use Win32::ODBC instead of DBI with DBD::mysql? The latter is probably easier to install and use.
How exactly did you install Win32::ODBC?
Does it work if you execute it locally, ie not as CGI trough the web server?
(Update: fixed typo)
| [reply] |
require "cgi-lib.pl";
Do NOT use that. Use CGI.
use Win32::ODBC;
Do NOT use that. Use DBI and DBD::mysql.
Look in the Tutorials section of this site to see some tutorials on using CGI.pm and DBI.pm.
| [reply] |
I have download the mysql, dbd, ODBC, and other related modules from CPAN and copied it in the perl/lib and some in lib/win32 folder ..
That's not the proper way to install a module, and not sufficient for this module.
If you're using ActivePerl, the simplest way is probably to execute the following command from the command prompt:
ppm install DBD-mysql
Update: Oops, the install procedure I gave is for a the DBI driver for MySql, not Win32::ODBC. It's probably what you should be using anyway.
| [reply]
[d/l] |