Re^2: (mysql) failing to locate object method

hi Gilimanjaro

after doing modifications said by u only one error i am getting, the coding is as follows :==>

use strict;
use warnings;

use DBI;
# Here's how to include the DBI module 
my $dbh;

my $db = 'myfirstdatabase';
   my $db_user = 'RAM';
   my $db_password = '';
   # Connect to the requested server 

   $dbh = DBI->connect("dbi:mysql:$db","$db_user", "$db_password",{Rai
+seError => 0, PrintError => 0} ) or err_trap("Cannot connect to the d
+atabase");
   my $sql;
   my $sth;
   my $td;
   $sql = "SELECT max(unxtmstmp) FROM logfl";
      
   $sth=$dbh->prepare($sql) or die "preparing: ",$dbh->errstr; 
   $sth->execute or die "executing: ", $dbh->errstr; 
   $td = $sth->fetchrow_array;
   print "$td";
[download]

==================================================

The error which i am getting when i run the above program is

C:\ram>perl timeinblt.pl
Can't locate object method "connect" via package "DBI" (perhaps you fo
+rgot to load "DBI"?) at timeinblt.pl line 14.
C:\ram>
[download]

the line no. 14 is

$dbh = DBI->connect("dbi:mysql:$db","$db_user", "$db_password",{RaiseError => 0, PrintError => 0} ) or err_trap("Cannot connect to the database");

Edited 3 Aug 2004, by footpad: Converted <br> tags to <P> tags and added <code> tags.

Comment on Re^2: (mysql) failing to locate object method Select or Download Code

Replies are listed 'Best First'.
Re^3: (mysql) failing to locate object method by Gilimanjaro (Hermit) on Aug 03, 2004 at 11:54 UTC
This almost certainly means something is not right with your DBI installation... Try adding `print "$_\n" for grep /^[a-z]/, keys %DBI::;` [download] after your 'use DBI;'. This single line will show you all symbols (including methods) in your DBI package after you've used it. If this list contains 'connect' then there's something wrong with your perl. If it doesn't, then something is wrong with your DBI. You could try reinstalling your DBI package maybe...	[reply] [d/l]
Re^4: (mysql) failing to locate object method by sriraj (Initiate) on Aug 03, 2004 at 12:16 UTC
hi Gilimanjaro thank u very much for giving the immediate response i tried to run the program as per ur instructions and i didnt get any output This is the program ==================== use strict; use DBI; print "$_\n" for grep /^a-z/, keys %DBI::; output of the program is ======================== C:\ram>perl mysqltest.pl C:\ram> can i know what could be the error, if it is dbi installing problem how can i uninstall the dbi package	[reply]
Re^5: (mysql) failing to locate object method by Gilimanjaro (Hermit) on Aug 03, 2004 at 12:58 UTC
This means DBI is not loaded properly, so it's probably not installed properly. I don't know much about ppm, but what I can find online seems to indicate you need to: `ppm remove DBI ppm install DBI` [download] I hope it helps....	[reply] [d/l]


We don't bite newbies here... much
	PerlMonks