Showing results for 
Search instead for 
Did you mean: 

Oracle 9 & Merant's ODBC Driver

Go to solution
Occasional Visitor

Oracle 9 & Merant's ODBC Driver


We have a hp-ux system with websphere MQ Integrator 2.1 (CSD4) and Oracle 9 database. We try to connect to the database with Integrator using Merant's odbc driver (supplied with the Integrator) but the following error occurs:

/usr/lib/ Can't find path for shared library:
/usr/lib/ No such file or directory

Oracle 9 does not have library - instead it has library.

Is this a known problem? Is the driver compatible with Oracle 9?

- Timo


Re: Oracle 9 & Merant's ODBC Driver

MQ Integrator seems to be compiled with reference to oracle 8i. You could make a simbolic link from to in $ORACLE_HOME/lib
Then it should work. Oracle 9 client library is compatible with previous releases
Johnny Kwok
Occasional Advisor

Re: Oracle 9 & Merant's ODBC Driver


We are in the processing of moving our Websphere 4.05 running on a HP Server (N4000) with HP UX 11.0 and ORACLE 8.1.7. to HP Server RP7410 with HP UX 11i and ORACLE 9i (9.0.2).

During testing, developers reported "ODBC" drivers problem for the applications with ORACLE 9i, they ended up using the 8.1.7 "ODBC" drivers instead and then everything works.

Hope it helps!

Occasional Visitor

Re: Oracle 9 & Merant's ODBC Driver

Thanks Marian. That resolved our problem.

BG, Timo
Wendy Dube
Occasional Visitor

Re: Oracle 9 & Merant's ODBC Driver

I am running wmqi broker 2.1 on Unix and i am inserting XML data onto a remote oracle database(Unix).

When the XML data I am inserting is small (> 4 KB) it works, but when I put big message (> 9kb). I get the error:

[MERANT][ODBC Oracle 8 driver] Invalid precision value.6044'

The column I am inserting in is data type CLOB.

One of the posting suggested I use oracle drivers instead of the Merant WMQI drivers (/opt/wmqi/merant/lib/ How do I go about doing this?

The local server has oracle client 8.1.7 and the remote server has oracle version 8.1.7 on Sun Solaris 9.

Please help.