I had some minor success! I switched to /usr/lib/mysql and as root did:
ln -s libmysqlclient.so.15 libmysqlclient.so
Then, still as root, did:
ldconfig -v
under /usr/lib it showed:
libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0
Then I did:
/sbin/ldconfig -p |grep mysql
which returned:
libmysqlclient_r.so.15 (libc6) => /usr/lib/libmysqlclient_r.so.15
libmysqlclient.so.15 (libc6) => /usr/lib/libmysqlclient.so.15
Next,
file -L /usr/lib/mysql/libmysqlclient.so
Which returned:
/usr/lib/mysql/libmysqlclient.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), stripped
I then ran the original console program you had written using:
h := loadlibrary('libmysqlclient.so');
but it returned "fail"
Then I ran it with:
h := loadlibrary('/usr/lib/mysql/libmysqlclient.so');
and it returned "success" !!!!!!!!!!!!:D
I think the loadlibrary('libmysqlclient.so') failed because without the path, it will look in /usr/lib and libmysqlclient.so is not there ???? Also, since I am in SUSE 10.2, my /etc/ld.so.conf.d does not contain "mysql-i386.conf". Maybe I need to do a sym link to usr/lib ??? Would this make sense:
(executing from /usr/lib/mysql)
ln -s libmysqlclient.so.15 /usr/lib/libmysqlclient.so
?????? If so should I remove the sym link I just put in /usr/lib/mysql ?