DBI works under Apache. Apache::DBI just gives you some performance gains like
persistent connections etc. Get the script working with DBI under Apache and
then start messing with Apache::DBI. Your problem is that you need to print
"Content-type: text/html\n\n"; before you print anything else. (CGI basics).
Greg Cobb wrote:
> I can run this simple script through perl itself, but when I put it in the
> cgi-bin and try to run it using mod_perl Perl pops up in windows with an
> error. I assume this means I need something like Apache::DBI?... I
> originally got Apache in binary form with mod_perl installed and did not
> have to compile anything. I tried to follow the instructions but i dont
> seem to be able to build Apache::DBI
> I ran
> perl makefile.pl which creates a file called makefile
> then the instructions tell you to run
> make
> make test
> make install
>
> make by run by itself says 'No terminator specified for in-line operator'
> and i dont have a test or install file that came with the Apache:DBI
> download. I have a test.pl but that doesnt seem to be what i need. I am
> running Win 98se if that helps. Anyone have any suggestions?
>
> Here is the code I tried to run.
> #!\perl\bin\perl
> use DBI;
> $dbh = DBI->connect('dbi:ODBC:Test1Db');
> $sqlstatement="SELECT * FROM ASTAB";
> $sth = $dbh->prepare($sqlstatement);
> $sth->execute ||
> die "Could not execute SQL statement ... maybe invalid?";
>
> #output database results
> while (@row=$sth->fetchrow_array)
> { print "@row\n" }
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Mark Maunder
Senior Architect
SwiftCamel Software
http://www.swiftcamel.com
mailto:[EMAIL PROTECTED]
