Hi,

I'm trying (first time) to connect to a mysql database out of a Perl script.
I'm using RedHat's Fedora 3 and have DBI, DBD::mysql and DBD::mysqlsimple 
already installed.

I'm allways getting the message:

perl: symbol lookup error: 
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mysql.so: 
undefined symbol: DBIc_TRACE_LEVEL

I tried two different ways:

1)=====================
use DBI;
my ($dbh, $sth, $count);
$dbh = DBI->connect ("DBI:mysql:host=localhost;database=cpngx",
                                        {PrintError => 0, RaiseError => 1});


2)======================
use DBI;
use DBI::Mysqlsimple;

my $db1 = DBI::Mysqlsimple->new('cpngx','localhost','jka','Euro2004');

my  ($name,$type,$ip_mem,$mask) = $db->get_row("select * from cpobjects where 
type = 0");

my $rows = $db->get_rows("select * from cpobjects where type = 0");
for my $r (@rows) {
       print $r->{name}, $r->{type}, $r->{ip_mem}, $r->{mask}, "\n";
}
===========================================

Some ideas what it could be?

Thanks in advance

jannis



Reply via email to