|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 21st, 1999, 03:39 AM
|
|||
|
|||
|
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)
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > DBI MySQL cannot connect. Help ! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
