CGI ERROR RELATING TO MYSQL

raviguhani has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: CGI ERROR RELATING TO MYSQL by ysth (Canon) on Aug 17, 2007 at 19:45 UTC
Win32::ODBC is using AutoLoader, which means that if you call subroutines in that package that don't exist, it will try to load the code for them from an .al file. So something you are doing is erroneously trying to call Win32::ODBC::mySql. (Update after seeing others posts: AutoLoader is dumb. The "Can't locate ... .al" error can mean an improper installation, or it can mean someone calling a sub that doesn't exist at all.)	[reply]
Re^2: CGI ERROR RELATING TO MYSQL by raviguhani (Initiate) on Aug 17, 2007 at 20:07 UTC
thanks monk,	[reply]
Re: CGI ERROR RELATING TO MYSQL by holli (Abbot) on Aug 17, 2007 at 19:45 UTC
.al files are used by the AutoLoader module. Missing al files normally are a sign for an incomplete installation of a module (here DBD::ODBC). Try a reinstall. But. You will be better of using DBD::mysql rather than DBD::ODBC. holli, /regexed monk/	[reply] [d/l]
Re: CGI ERROR RELATING TO MYSQL by mr_mischief (Monsignor) on Aug 17, 2007 at 19:43 UTC
Unless you have a specific reason to be using MySQL through ODBC, you might try DBI and DBD::mysql instead. How did you install Win32::ODBC? Do you have the http://www.mysql.com/news-and-events/news/article_88.htmlMySQL ODBC drivers for Windows? Do you have modules in other directories so that you might need to adjust your include paths?	[reply]