MQSeries.net :: View topic - AIX5L ODBC driver for Oracle8

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » AIX5L ODBC driver for Oracle8

AIX5L ODBC driver for Oracle8

« View previous topic :: View next topic »

Author

Message

jby

Posted: Wed Jun 25, 2003 8:30 am Post subject: AIX5L ODBC driver for Oracle8

Newbie

Joined: 24 Jan 2003
Posts: 9
Location: Netherlands

Hi,
We moved our WMQI2.1 broker from AIX4.3.3 accessing Oracle8 to
WMQIV2.1 CSD04 on AIX5L (oslevel =5.1.0.0).

To allow our broker establish ODBC connection to a remote Oracle8 DB , we tried first with Oracle8 Client software, and later with Oracle 9i Client software (32-bit), using using the Merant drivers i.e. with the following in our .odbc.ini file
Driver=/usr/opt/wmqi/merant/lib/UKor816.so

When the broker tries to connect we get the following in the trace...

DatabaseException BIP2322E: Database error: SQL State 'IM003'; Native Error Code '80';
Error Text 'Specified driver could not be loaded'.

Has anyone experience of WMQI2.1 on AIX5L accessing remote Oracle8 database and if so which ODBC drivers are configured?

jby

Posted: Tue Jul 01, 2003 8:43 am Post subject:

Newbie

Joined: 24 Jan 2003
Posts: 9
Location: Netherlands

The remote Oracle database is Oracle 8.1.7.
The system administrator installed Oracle 9i Client software on AIX5L, as the Oracle8 Client would not work (without kernel updates). It seemed that 'sqlplus' did not work.

1) When I try
mqsi_setupdatabase oracle8 $ORACLE_HOME
I get an error from the message flow saying that the 'specified driver could not be loaded'

2) When I try
mqsi_setupdatabase oracle9 $ORACLE_HOME
I get errors from the message flow SELECT stmt saying
DatabaseException BIP2324E: Unsupported datatype '-9' fetched from database table colum 'XXX'.
where XXX always seems to be the first column specified for retrieval. Interestingly, INSERTS seem to work.

I was convinced that it did work once (a Friday afternoon test) after experimenting with profile/path settings.
But I cannot reproduce the situation.

Note: The same broker flow using the same Oracle DB works from AIX4.3.3 and NT as expected.

My question:
In the mqsi_setupdatabase command is the 'database' parameter the target or client (i.e. in our case the target is oracle8 , the client software is oracle9)?

Anyone using a similar - but working - configuration on AIX5L ?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » AIX5L ODBC driver for Oracle8

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP