odbc libraries

UNIX Solaris
1

Hi,

this is my first experience with Solaris.

For work, I must configured an applicacion (oracle EPM, this include Datadirect odbc drivers) in solaris.

Additionally, we must connect to Sybase IQ Database (I installed odbc drivers to do this).

The problem is, I can't get those two odbc libraries to work.

when I set:

LD_LIBRARY_PATH=/opt/Sybase/odbc/lib:/opt/Datadirect/lib:${LD_LIBRARY_PATH}
Sybase works fine, and when I try to connect to MsSQL database doesn't work

LD_LIBRARY_PATH=/opt/Datadirect/lib:/opt/Sybase/odbc/lib:${LD_LIBRARY_PATH}
Sybase works fine, and when I try to connect to MsSQL database doesn't work

Is there a way to configure two different sources for odbc drivers ?
thanks in advance.
Daniel.

2

try - i'm HP-UX !!!

export ODBCHOME=/opt/odbc/odbc92_v6 
export ODBCINI=$ODBCHOME/obdc.ini 
 
# Set up the Shared Library Path: 
SHLIB_PATH=/u01/app/oracle/product/10.2.0/lib:$ODBCHOME/lib:/usr/local:/
opt/IBM/db2/V9.1/lib64:$SHLIB_PATH

kind of stuck myself...

can't override LD_LIBRARY_PATH ...

---------- Post updated at 03:06 PM ---------- Previous update was at 03:03 PM ----------

also -
i have

 ga016a501 -> cat .profile1 | grep -i ld_lib | more                             
        #export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/ccs/lib:         
        #unset LD_LIBRARY_PATH                                                  
        LD_LIBRARY_PATH=/opt/odbc/odbc92_v6/lib:/home/uzdbwhi0/sqllib/lib64:/hom
e/uzdbwhi0/sqllib/lib32                                                         
        export LD_LIBRARY_PATH

i get

[/home/uzassi0 - uzassi0] 
ga016a501 -> env | grep -i ld_lib 
D_LIBRARY_PATH=/home/uzdbwhi0/sqllib/lib64:/home/uzdbwhi0/sqllib/lib32

GRRRRRRRR..