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]