Hi all.
I am in desparate need of advice.
I am running a NT4.0/IIS server and a MSSQL7 database. I ahve got Perl
working fine on the Web Server but I cannot perform simple function on
the Database. Below is my code and the different error's I recieve when
I alter the code. I hope it makes sence. One of the problem's is that I
am not 100% sure that I am connecting to the DB. Before I was getting
Connect errors and then I changed the connect string and they stopped so
I can only asume no errors means no problems, Ok you can stop laughing
now.
Anyway Please help
Kind Regards
Justin
Sript
#!/usr/local/bin/perl5
use DBI;
$dbh = DBI.connect("DBI:ODBC:database=**", "**");
#print "Content-Type: text/html\n\n";
#$SQL="select name from test";
$dbh->do($SQL);
$sth = $dbh->prepare($SQL);
$sth->execute();
while (($boy) = $sth->fetchrow)
{
print "debug $boy";
}
$sth->finish();
$dbh->disconnect();
###################################################
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 auto/DBI/do.al in @INC (@INC contains: C:/Perl/lib
C:/Perl/site/lib .) at D:\Web_Clients\test\cgi-bin\db.pl line 20
######################################################################
Then with no hash by the $SQL="select ......" same error
Then with line 16 "Content-type etc" not hashed I just a get a blank
page and when I try view the source nothing comes up.
