Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Combining ODBC & CGI

by Stu (Initiate)
on Feb 02, 2000 at 13:26 UTC ( #2715=perlquestion: print w/replies, xml ) Need Help??
Stu has asked for the wisdom of the Perl Monks concerning the following question:

I've been mucking around trying to get dump stuff from a database to a web page. This what I came up with (I'm a win32 user - forgive me brothers):
use CGI qw(-no_debug :standard); use Win32::ODBC; $db = new Win32::ODBC("LIB"); $stmt = "SELECT * FROM Library WHERE Number > 1800"; $rc = $db->Sql($stmt); die qq(SQL failed "$stmt": ), $db->Error(), qq(\n) if $rc; print header(), start_html("Test Library"); while($db->FetchRow()) { @Data = $db->Data("Number","Title"); print "$Data[0] $Data[1]<br>\n"; } print end_html(); $db->Close();
This works fine from the command line... no problems connecting to database or with sql statement, all html codes correct and accounted for. When I invoke it in a browser I get: CGI Error... Can't call method "Sql" on an undefined value at C:\InetPub\wwwroot\cgi-bin\ line 7 Is this a Perl problem or an IIS (again, forgive me) problem? Any advice gratefully recieved.

Replies are listed 'Best First'.
Re: Combining ODBC & CGI
by chromatic (Archbishop) on Feb 03, 2000 at 02:16 UTC
    It looks as if the $db object didn't get defined. Try a die statement on the fourth line: $db = new Win32::ODBC("LIB") || die "Can't get db handle: $!";
    Could be a permissions issue. (Then again, I don't use IIS and databases together.)
      Doh! Silly me. Yes, it is a permissions issue. Works fine now. Thanks for your help.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://2715]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (3)
As of 2018-05-26 13:05 GMT
Find Nodes?
    Voting Booth?