DBD::Mysql module installation problem

Hello 

I am using mysql 4.1.13 from mysql.com

operating system 

SunOS sun-sl-dor-2 5.8 Generic_117350-27 sun4u sparc
SUNW,UltraSPARC-IIi-cEngine
perl version

This is perl, v5.8.7 built for sun4-solaris

gcc,make,DBI 1.18 ,DBD-mysql 2.9008

I am using following to compile to compile DBD::mysql 

perl Makefile.PL --cflags="-I/usr/local/mysql/include"  
--libs="-L/usr/local/mysql/include
-L/opt/csw/gcc3/lib/gcc-lib/sparc-sun-solaris2.8/3.3.3 -lgcc
-L/tmp/mysql-static -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm
-lmysqlclient" 

I checked lgcc path and given it in --libs as suggested by
install.html in DBD::module
also trying workaround is using a statically linked mysqlclient
libmysqlclient.a

as i do not have libmysqlclient.so in mysql/lib 

i also have linked /usr/ucb/cc to gcc as all modules are compiled
using gcc.

still i am getting this error when i do make test

Please suggest

install_driver(mysql) failed: Can't load
'/software/modules/old/DBD_mysql/DBD-mysql-2.9008/blib/arch/auto/DBD/m
ysql/mysql.so' for module DBD::mysql: ld.so.1: perl: fatal: relocation
error: file
/software/modules/old/DBD_mysql/DBD-mysql-2.9008/blib/arch/auto/DBD/my
sql/mysql.so: symbol mysql_real_escape_string: referenced symbol not
found at /usr/local/lib/perl5/5.8.7/sun4-solaris/DynaLoader.pm line
230.

strange thing is I have got same setup working on other solaris 8
machine.

Please help me to identify the exact problem

Thanks
mali
_________________________________________________________________

This e-mail may contain confidential information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful.

If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software.

The Friends Provident group of companies includes these Friends Provident plc subsidiary companies:

Friends Provident Life and Pensions Limited. Registered number 4096141.
Friends Provident Life Assurance Limited. Registered number 782698.
Friends Provident Pensions Limited. Registered number 475201.
Friends Provident Marketing Limited. Registered number 5059179.

Each of these subsidiary companies is authorised and regulated by the Financial Services Authority.

The ultimate holding company is Friends Provident plc. Registered number 4113107.

All are incorporated companies limited by shares and registered in England.
Registered and Head Office: Pixham End, Dorking, Surrey RH4 1QA.
www.friendsprovident.com

_________________________________________________________________

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]