My guess would be permissions and how you have your mysql server setup.
When you're running the script on the terminal, it's using your ID to
connect to the database server. When the webserver's running the script,
it's using the server process' ID.
I'm not sure if that's the right answer, though - GURUs: do databases answer
anonymous requests & provide the names of the available sources, no matter
who's requesting it?
Jason
----- Original Message -----
From: "Guillaume Denizot" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 4:45 AM
Subject: Sources
Hello,
when I execute this script :
"#!/usr/bin/perl -w
use DBI;
print "Content-type:Text/html\n\n";
print "<b>Pilotes disponibles:</b><br>\n";
@drivers=DBI->available_drivers;
foreach(@drivers)
{
print "$_ <br>\n";
}
$driver="mysql";
@sources=DBI->data_sources($driver);
print "\n<br><b>Sources de donnees disponibles:</b><br>\n";
foreach(@sources)
{
print "$_ \n<br>";
}"
with the terminal, I obtain:
"Pilotes disponibles:
ADO
ExampleP
Multiplex
Proxy
mysql
Sources de donnees disponibles:
DBI:mysql:mysql
DBI:mysql:test"
but when this script is called in HTML page like
"<form action="/cgi-bin/my_script.pl" method="POST">"
I obtain only:
"Pilotes disponibles:
ADO
ExampleP
Multiplex
Proxy
mysql
Sources de donnees disponibles:"
Why not sources of mysql driver?
Thanks...
_________________________________________________________
Le journal des abonn�s Caramail - http://www.carazine.com
