HI,
WE ARE STILL ENCOUNTERING PROBLEMS WITH DBI. FOLLOWING IS THE PERL SCRIPT WE ARE USING AND ALSO THE BROWSER ERROR IS MENTIONED. PLEASE ADVISE HOW WE CAN GET PERL TO CONNECT WITH MYSQL.

Thank you for your time & effort.

Server: WinNT.

PERL SCRIPT:

print "content-type:text/htmlnn";
print "<html>";
print "<head>";
print "<title>test programme</title>";
print "</head>";
print "<body>";
use DBI;
$port = 3306;
$hostname = "localhost";
$driver = "mysql";
$database = "login";
$dsn = "DBI:$driver:database=$database;host=$hostname;port=$port";
$user = " ";
$passwd = " ";
$dbh = DBI->connect($dsn, $user, $password);
die unless $dbh;
die $dbh->errstr if $dbh->err;
print "reached 1";
my $sql = qq{SELECT id,passwd FROM test};
my $sth = $dbh->prepare( $sql );
print "reached 2";
$sth->execute();
print "reached 3";
my( $name, $id);
$sth->bind_columns( undef,$id, $name);
while ($sth->fetch())
{
print "EmpName:$name EmpNum:$id<br>";
}
die $dbh->errstr if $dbh->err;
$sth->finish();
die $sth->errstr if $sth->err;
$dbh->disconnect;
print "</body>";
print "</html>";


BROWSER ERROR:
CGI Error

The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did
return are:

Can't locate DBI.pm in @INC at d:inetpublinkwithindiacgi-bintestmultidb.pl line 7.
BEGIN failed--compilation aborted at d:inetpublinkwithindiacgi-bintestmultidb.pl line 7.




Rohin Sadh.
sadh@vsnl.com
ICQ # 31415379

Thsis is what our hosting co said:
----- Original Message -----
Subject: Re: mysql and DBI


Hello,
Are you using the following?
DBI server = localhost
DBI driver = mysql
Username = your domain's default user
Password = your mysql password
Please try that and let us know if works for you.
Regards,
Marnie (Support)