| Author |
Message
|
| vk |
 Posted: Wed Jan 11, 2006 3:26 pm Post subject: Connecting to a Remote Oracle Database v9.2.0.4 |
 |
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Hi,
I have a requirement in which my message flow has to connect to a remote Oracle database (version 9.2.0.4) on AIX and insert records into some of the tables there.
I am using WMQI v2.1 which comes along with Merant 3.70 Oracle 8 Driver. Is it possible to connect to Oracle 9.2 with this ODBC driver?
I am getting the error 'Specified Driver could not be loaded'. Can anyone tell me if it is possible to connect to Oracle 9.2 with the merant ODBC driver which comes along with the installation?
Thanks,
VK. |
|
| Back to top |
|
 |
| JT |
| Posted: Wed Jan 11, 2006 4:25 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Have you set the requisite ORACLE_HOME and ODBCINI environment variables ?
Post the contents of .odbc.ini |
|
| Back to top |
|
|
| vk |
| Posted: Wed Jan 11, 2006 10:39 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Hi,
These are the settings which I did.
Environment Variables -
ORACLE_HOME = /usr/lpp/oracle/product/9.2.0
LD_LIBRARY_PATH = /usr/lpp/oracle/product/9.2.0/lib32:/usr/lpp/oracle/product/9.2.0/network/lib32
ODBCINI = /var/wmqi/odbc/.odbc.ini
.odoc.ini settings -
[ODBC Data Sources]
ABCPROD=MERANT 3.70 Oracle 8 Driver
[ABCPROD]
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle9.2
ServerName=abcprod.world
EnableDescribeParam=1
OptimizePrepare=1
tnsnames.ora settings -
abcprod.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rs240abc1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = abcprod)
)
)
Please let me know if this is fine.
Thanks,
VK. |
|
| Back to top |
|
|
| JT |
| Posted: Wed Jan 18, 2006 2:42 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Were you able to resolve this problem ? |
|
| Back to top |
|
|
| vk |
| Posted: Wed Jan 18, 2006 10:43 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Yes. I could.
I had not restarted the broker after installing the Oracle clinet. So the environment variables settings in etc/profile were not recognised by the broker.
Anyways, thanks for the help.
Regards,
VK. |
|
| Back to top |
|
|
| Ian |
| Posted: Thu Jan 19, 2006 6:57 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
The configuration you have detailed here is not supported because WMQI v2.1 with the Merant 3.70 Oracle 8 Driver does not support Oracle 9iR2.
The WMQI v2.1, Oracle and database driver relationship is as follows :
1. WMQIv2.1.0 CSD04 shipped with the Merant 3.7 driver --> MERANT 3.70 Oracle8 Driver
This provides support for the following Oracle client versions :
Oracle 8i Release 2 (V8.1.6)
Oracle 8i Release 3 (V8.1.7)
Oracle 9i Release 1 (9iR1) (V9.0.1)
2. WMQIv2.1.0 CSD05 shipped with the Merant 4.1 driver --> MQSeries DataDirect Technologies 4.10 32-BIT Oracle
This provides support for the following Oracle client versions :
Oracle 9i Release 2 (9iR2) (V9.0.2)
_________________
Regards, Ian |
|
| Back to top |
|
|
| JT |
| Posted: Thu Jan 19, 2006 10:42 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
[ODBC Data Sources]
ABCPROD=MERANT 3.70 Oracle 8 Driver
[ABCPROD]
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle9.2
ServerName=abcprod.world
EnableDescribeParam=1
OptimizePrepare=1 |
The comment in the description may be mis-leading. I thought the UKor818 supported the 4.10 driver and UKor816 supported 3.70. |
|
| Back to top |
|
|
| vk |
| Posted: Thu Jan 19, 2006 12:17 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
I am using WMQI 2.1 with CSD 8. I am not very sure about the version of Merant driver. That was the description in the ODBC.ini file.
Anyways I am able to connect to the Oracle database from the message flow. So I should be having Merant 4.1 driver.
Regards,
VK. |
|
| Back to top |
|
|
|
|
