Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

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\library.pl line 7 Is this a Perl problem or an IIS (again, forgive me) problem? Any advice gratefully recieved.

Comment on Combining ODBC & CGI
Download Code
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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://2715]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (6)
As of 2015-08-01 00:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (285 votes), past polls