PERL DBI for MySQL question

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/mysq l/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=$useri d;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=gcdmp-msql-mysql-modules [at] m .gmane.org
Laura Scott [ Do, 22 Juli 2004 15:54 ] [ ID #180747 ]
Datenbanken » gmane.comp.db.mysql.perl » PERL DBI for MySQL question

Vorheriges Thema: Per-database handle mysql_use_result
Nächstes Thema: PERL DBI for MySQL question