Hi All,
Recently I installed unixODBC(2.2.3) and MySql and MyODBC on Redhat
9.0. After the installation, I am able to use test program isql to
connect to the database I created with mysql.

However, if I run my application (linked with -lodbc), in SQLConnect
it will get the following error:

Message: [unixODBC][Driver Manager]Can't open cursor lib 'libodbccr' :
/lib/libo
dbccr.so.1: cannot open shared object file: No such file or directory

In isql (test utility), the SQLConnect() has been tested, why my
application had such problem? Also, libodbccr.so.1 is in
/usr/local/unixODBC/lib directory in my enviroment, I also added the
path to both LD_LIBRARY_PATH and LTDL_LIBRARY_PATH.

I had the above problem with both RPM verison and my own build version
of unixODBC.

The difference of isql and my application is isql is linked with
libtool and my application is linked by g++ with -lodbc option.

Please help me on the issue and please cc my email :
bangdu@cogentsystems.com

Thank you very much for your help.


Regards,
Bang