Help CGI PerlQuery.pl example

Posted in 1999

Todd Bair — Tue, 03 Aug 1999 11:31:53 -0500 — source: Informix-list mailing list archive (1991-1998)

I can't seem reproduce your PerlQuery.pl example. I get the following error when run as cgi. Customer Report Error: Could not connect SQL: -461: <<Failed to locate SQL error message>> However, if I run it from the command line it works fine and I get the following... Customer Report Name Company Address Phone Albertson, Frank Sporting Place 947 Waverly Place Redwood City, CA 94062 415-886-6677 Baxter, Dick Blue Ribbon Sports 5427 College Oakland, CA 94609 415-655-0011 ... Report run on Tuesday, August 3rd, 1999 at 15:17:48 UTC Here is my configuration info... Informix 7.24.UC2 Solaris 2.5.1 Apache 1.3.6 Perl 5.005.03 CGI 2.53 DBI 1.10 DBD::Informix 0.60 INFORMIX-ESQL 9.20UC3 The only thing I've changed in the script is commenting out the lines with "ibyx", and the folowing in the connection part.. my $dbh=DBI->connect( 'dbi:Informix:stores', 'username', 'password', { 'PrintError'=>1 } ) or fatalerror( $q, "Could not connect" ); I've read the readme's and the examples on-line. Now I'm stumped. Can you tell me what I need to configure? Thanks, -- Todd A. Bair Sun / dB Admin. Mixed Signal Process Development E-MAIL: todd@ti.com