[prev in list] [next in list] [prev in thread] [next in thread] 

List:       msql-mysql-modules
Subject:    PERL DBI for MySQL question
From:       Laura Scott <l.e.scott () larc ! nasa ! gov>
Date:       2004-07-22 13:54:24
Message-ID: 40FFC710.1039AF86 () larc ! nasa ! gov
[Download RAW message or body]

Hello,

I am trying to connect to a MySQL database using PERL DBI.  I have been
told that the DBI driver for MySQL has been installed correctly by my SA
team.  However, I am still getting the error "install_driver(mysql)
failed: Can't load
'/usr/perl5/site_perl/5.6.1/sun4-solaris-64int/auto/DBD/mysql/mysql.so'
for module DBD::mysql: ld.so.1: perl: fatal: libmysqlclient.so.12: open
failed: No such file or directory at
/usr/perl5/5.6.1/lib/sun4-solaris-64int/DynaLoader.pm line 206."

I get this using the connect statement
$connect="DBI:mysql:database=$dbname;$host";
$dbh = DBI->connect($connect,$userid,$dbpasswd);

and have tried

$dbh =
DBI->connect("dbi:mysql:database=dmss;host=$host;user=$userid;password=$dbpasswd")
or die "cant open db $DBI::errstr\n";

I have modified my LD_LIBRARY_PATH to include the path to mysql and was
wondering what else I might be missing.  Or what I could do to verify
that the driver was in fact installed correctly?

Any help would be greatly appreciated.

Laura Scott



-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=msql-mysql-modules@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]