#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    7
    Rep Power
    0
    Help me anyone?
    I am running winNT.40 work station, with option pack and PWS. I have insstalled mysql-shareware version. I have installed from ActiveState Perl- build613. I have DBI, DBD-mysql, DBD-ODBC modules installed
    I have created a data base "people' with a table "phones" in mysql.
    I HAVE THIS CGI SCRIPT IN THE CGI-BIN DIR. of PWS
    --------
    #!/usr/bin/perl -w
    # print-table.cgi - print contents
    of a table as HTML
    print "HTTP/1.0 200 OKn";
    print "Content-Type: text/htmlnn";
    use DBI;
    use CGI qw(:standard *table :html3);

    print header(),
    start_html("All the People"),
    start_table();

    $dbh = DBI->connect("DBI:mysql eople",
    "ugtn5", "sada",

    { RaiseError => 1 });
    $sth = $dbh->prepare("SELECT * FROM phones");
    while (@row = $sth->fetchrow_array) {
    print Tr(Td( [ @row ] ));
    }
    print end_table(),
    end_html();

    $sth->finish();
    $dbh->disconnect();
    ---------------
    I get a meessage, 'the cgi script produced no output' when I run this script .
    What other modules am I missing? Do I need a special ODBC administator.?
    "DBI:ODBC:xxx.mdb" works OK
    mysql and php scripts that I have, work OK.
    What am I doing wrong? What is missing?

  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 1999
    Posts
    33
    Rep Power
    16
    does it work properly if you run it from the command line? what does it say?
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    7
    Rep Power
    0
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by Imo:
    does it work properly if you run it from the command line? what does it say?[/quote]
    I am getting no output. There are no error messages. This is what I get:

    'F:Inetpubwwwrootcgi-bintark.cgi' script produced no output

    Need I configure ODBC as I do for Access databases?
    Thanks


IMN logo majestic logo threadwatch logo seochat tools logo