Hi, I am using Net::mysql to connect with database mysql.Though sytax is correct it is still giving error:
Can't locate object method "new" via package "MySql" (perhaps you forgot to load "MySql"?) at E:\PERLTR~1\perl\VALIDA~1.PL line 10. Content-type:text/html My code 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=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]; } $mysql->close; I have tried other modules also like DBI,DBD but still I am getting same error.What may be the reason .I have installed these modules through ppm .Can anybody help me? Thanks in advance ! Pankaj.