Hi,
I am trying to connect to MYSQL through my perl script.I am using windows 2000 and 
activeperl.
I am using Net::MySQL to connect with database.But it is giving error :
Couldn't connect to /tmp/mysql.sock: at E:\PERLTR~1\perl\VALIDA~1.PL line 12 
My script is as follows:
#!/usr/local/bin/perl
print "Content-type:text/html\n\n";
use Net::MySQL;


$DBHOST = "localhost";
$DBNAME = "sitebuilder";

$DBUSER = "sa";
$DBPASS = "";

my $mysql= Net::MySQL->new($DBHOST, $DBNAME ,  $DBUSER, $DBPASS);
$mysql->query(q{SELECT sLoginId,sFirstName,sLastName FROM userdetail});

my $record_set = $mysql->create_record_iterator;
  while (my $record = $record_set->each) {
      printf "First column: %s Next column: %s\n",
          $record->[0], $record->[1],$record->[2];
  }

Please Can u help me?
Thanks in advance!
Pankaj

Reply via email to