RE: [OT] DBI-ODBC WIN2K

[Eduardo Cancino]

here is the source of my cgi


use DBI;
use CGI qw(:standard);
use CGI::Carp ('fatalsToBrowser');

my $dbh = DBI->connect ( "dbi:ODBC:database", "admin", "all" ) or die "No
pude conectarme : $DBI::errstr\n";

my $sth = $dbh->prepare( "SELECT titulo, id, fecha FROM table1 ORDER BY id
                                                " );
$sth->execute();

print "<h1>$title</h1>";

print "<ol>";
while ( (my $name, my $id, my $time) = $sth->fetchrow) {
                print "<li><a href='cgi.pl?id=$id'>$name</a>- $time</li>\n\n";
}
print "</ol>";
print "<br />";
print "<br />";
print "<br />";

-----Mensaje original-----
De: David Kirol [mailto:[EMAIL PROTECTED]]
Enviado el: Martes, 23 de Abril de 2002 02:45 p.m.
Para: Eduardo Cancino
Asunto: RE: [OT] DBI-ODBC WIN2K


Eduardo,
        Review your connect string. Make sure a user is specified. If not the CGI
script's 'user' (usually nobody) will be passed and the db will reject it.
HTH

-----Original Message-----
From: Eduardo Cancino [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 3:27 PM
To: List Beginners Perl
Subject: [OT] DBI-ODBC WIN2K


I have this problem now, maybe is not about perl but here I go:

I connected an Access Datasource to a cgi, (made in Perl ;), but while in
the command line runs perfectly, as a CGI, on my host, it outputs:

Software error:
No pude conectarme : (DBD: db_login/SQLConnect err=-1)

I know that maybe is a users problem and I have read the IIS
"documentation", but I can't find something useful, do you know where can I
read about this?

Thanks!

lalo.


--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]