Gossamer Forum: General: Perl Programming: DBI connection "error"

Gossamer Threads

Home : General : Perl Programming :

DBI connection "error"

Dec 19, 2003, 1:21 PM

seth_h

New User (4 posts)

Dec 19, 2003, 1:21 PM

Post #1 of 2

Shortcut

DBI connection "error"

HELP! When I try to connect to my database I am getting the following "error." (I used quotes for a reason) When I run my script from a command prompt, it connects to the database and returns all rows exactly as expected. When I run it from a web browser, though, I get the following error message:

Can't call method "prepare" on an undefined value at C:\cgi-bin\returnauction.cgi line 7.

This is my DBI initialization:
$database = DBI->connect ("DBI:ODBC:AuctionData",{PrintError => 1, RaiseError => 1});

I don't understand how the connection to my database can be OK when run from a prompt, but be undefined when run from a browser. Any help is very much appreciated as I think that Google is getting tired of spitting out worthless results to my requests. Thanks.

--Seth

Dec 20, 2003, 2:28 AM

Andy

Veteran / Moderator (18441 posts)

Dec 20, 2003, 2:28 AM

Post #2 of 2

Shortcut

Re: [seth_h] DBI connection "error" In reply to

You don't seem to be using a username/password. This works just fine for me;

Code:
    my $dbh = DBI->connect ("DBI:mysql:database_name:localhost", "user", "pass", {PrintError => 0, RaiseError => 1}) or die print "Cannot connect to database: ", $!; 

    my $sth= $dbh->prepare ("SELECT * FROM Countries"); 
    $sth->execute(); 
    while (my $hit = $sth->fetchrow_hashref()) { 
      print $hit->{Name} . "<BR>";  
    }

Cheers

Andy (mod)
andy@ultranerds.co.uk

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676