odbc libraries


 
Thread Tools Search this Thread
Operating Systems Solaris odbc libraries
# 1  
Old 10-18-2011
odbc libraries

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:
Code:
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.


Moderator's Comments:
Mod Comment Please use code tags <- click the link!

Last edited by zaxxon; 11-02-2011 at 03:13 AM.. Reason: code tags, see PM
# 2  
Old 10-26-2011
try - i'm HP-UX !!!

Code:
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
Code:
 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
Code:
[/home/uzassi0 - uzassi0] 
ga016a501 -> env | grep -i ld_lib 
D_LIBRARY_PATH=/home/uzdbwhi0/sqllib/lib64:/home/uzdbwhi0/sqllib/lib32

GRRRRRRRR..

Moderator's Comments:
Mod Comment Please use code tags <- click the link!

Last edited by zaxxon; 11-02-2011 at 03:14 AM.. Reason: code tags, see PM
Bill L.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

ODBC Hive error

Hi , I am trying to setup HIVE ODBC with below setting Host: Local host port : 10000 Database : Default Hive server type : Hive server 2 Mechanism: User But getting below error: Driver Version: V2.5.0.1001 Running connectivity tests... Attempting connection Failed to... (1 Reply)
Discussion started by: rakesh_411
1 Replies

2. Shell Programming and Scripting

Perl ODBC error

my question (8 Replies)
Discussion started by: sauravrout
8 Replies

3. Red Hat

Unix ODBC Issues

Hello, I'm trying to get an ODBC connection to Oracle 10g database by following the below steps: 1. Downloaded UnixODBC 2.2.14 binary and extracted the contents 2. Added the following lines to /etc/profile: LD_LIBRARY_PATH="/optware/unixODBC/lib/" export LD_LIBRARY_PATH... (0 Replies)
Discussion started by: sviswa30
0 Replies

4. Red Hat

odbc installation on linux.

HI All, I am trying to install odbc driver for mysql on linux red hat. when I try to install it using rpm then i get dependency error and when I try to find that dependent package then I am unable to find it on web. can you plz help me how can I install it. Thanks. # rpm -ivh... (3 Replies)
Discussion started by: mkashif
3 Replies

5. AIX

ODBC on AIX

I´m using an app that uses odbc to connect to the data base, i thought odbc was only available for NT plataforms...anybody knows how to create an odbc connection on AIX 5.1 (if possible). Thanks a lot (3 Replies)
Discussion started by: paulcarbajal
3 Replies

6. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ... (3 Replies)
Discussion started by: sameerstephen
3 Replies

7. UNIX for Dummies Questions & Answers

ODBC on UNIX

I see several questions regarding setting up ODBC on UNIX machines but I don't see any replies. I always thought ODBC was only possible on Windows machines, but I've recently heard drivers do exist for ODBC on UNIX. Does anyone know any more details about this: How to set up ODBC on UNIX, web sites... (1 Reply)
Discussion started by: ggmar
1 Replies

8. UNIX for Dummies Questions & Answers

ODBC Version

how to find the version of ODBC and the database drivers in Unix box :eek: (0 Replies)
Discussion started by: raghunath_mv
0 Replies

9. UNIX for Advanced & Expert Users

Aix 5.3 L Odbc

Dose anybody knows about Installation and setup of ODBC under AIX 5.3 L (0 Replies)
Discussion started by: uhdesai
0 Replies

10. UNIX for Advanced & Expert Users

Oracle Odbc

Hello all, i like to install an application program that will interact with the oracle database. oracle has been installed in /export/home/oracle does the new application has to be in the same directory and if not which one do you recommend? There is a drive like the ODBC in oracle to... (2 Replies)
Discussion started by: rsh
2 Replies
Login or Register to Ask a Question