hi list,
I'm running Embperl on my ISPs webserver, and when I execute the
following code (from the sample included with Embperl):
===
$DSN = 'dbi:mysql:mlanghoff' ;
$table = 'registros' ;
use DBI ;
# connect to database
$dbh = DBI->connect($DSN, 'mlanghoff', 'ml123') or die "Cannot connect
to '$DSN' $!" ;
# prepare the sql select
$sth = $dbh -> prepare ("SELECT * from $table") or die "Cannot SELECT
from '$table'" ;
# excute the query
$sth -> execute or die "Cannot execute SELECT from '$table'"; ##This
is line 29!!!
====
I get the following error :
[22828]ERR: 32: Line 15: Warning in Perl code: DBD::mysql::st execute
failed: ase Selected at
/usr/local/httpd/htdocs/intercosta/htmlf/dbi1.netizen.ehtml line 29.
[22828]ERR: 24: Line 15: Error in Perl code: Cannot execute SELECT from
'registros' at
/usr/local/httpd/htdocs/intercosta/htmlf/dbi1.netizen.ehtml line 29.
And the server signature:
Apache/1.3.4 (Unix) SuSE/6.0 PHP/3.0.6 mod_perl/1.17 HTML::Embperl 1.2.0
[Fri Nov 26 18:27:40 1999]
I've been told by the webmaster that DBI connections fail from ePerl
also, so maybe it's a mod_perl issue. Anyway, the webmaster doesn't care
much about it, but I ***must*** make it work.
Do you have any pointers as to where can I start debugging this
issue? The same code runs perfectly on my local linux, and DBI runs
great from any standard CGI scripts run with the standalone perl
interpreter.
Thanks in advance.
martin
--
- Martin Langhoff @ S C I M Multimedia Technology -
- http://www.scim.net | God is real until -
- mailto:[EMAIL PROTECTED] | declared integer -
