| Author |
Message
|
| jlalbor |
 Posted: Fri Mar 09, 2007 9:20 am Post subject: [ODBC Oracle driver]Optional feature not implemented |
 |
|
Apprentice
Joined: 18 Feb 2003
Posts: 38
|
Before yesterday I created a topic about this issue, but i have figured out the real problem (the odbc.ini file was using old Broker V5 merant drivers), so I decided to deleted that topic and create this one to expose the final situation.
The environment is
AIX 5.2 ML 9
MQ v 5.3 CSD 13
Broker 6 Fixpack 3
Oracle 10.1.0.4.0 is installed in the Broker box
I am trying to execute some queries and a stored procedure in a remote Oracle database. The remote Oracle database is Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
Well, the problem is that any querie I make to this database through the Broker throws the following error:
| Quote: |
Child SQL exception
HYC00.
0.
[DataDirect][ODBC Oracle driver]Optional feature not implemented |
I have made some test connecting the Broker to another remote Oracle database version 10.1.0.4.0 64 bit (the same version that is installed in the brokers machine) and the queries and stored procedures execute correctly.
That makes me think that the problem could be the oracle version. Is there any restrcition that says I can not use Oracle 10 to connect to a Oracle 9i database?
Maybe I am not using the correct driver version, but as far I have read in the manuals, there in no driver for 9i and 10g in the Brokers merant drivers.
Here is the odbc declaration in the odbc.ini file:
| Quote: |
[MARCH]
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
Description=Oracle 9i DB
EnableDescribeParam=1
OptimizePrepare=1
ServerName=march
WorkArounds=536870912
ProcedureRetResults=1 |
And here is the declaration of the database in the tnsnames.ora file in the brokers machine:
| Quote: |
march =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 172.16.203.17)(Port= 1521))
(CONNECT_DATA = (SID = MARCH))
) |
And here is the LIBPATH environment variable:
| Quote: |
| /u01/app/oracle/product/10g/lib32:/usr/mqm/java/lib:/opt/IBM/mqsi/6.0/classes:/opt/IBM/mqsi/6.0/lib:/opt/IBM/mqsi/6.0/bin:/opt/IBM/mqsi/6.0/merant/lib:/opt/IBM/mqsi/6.0/jre/bin:/opt/IBM/mqsi/6.0/jre/bin/classic:/opt/IBM/mqsi/6.0/xml4c/lib::/usr/db2/wbiadm/sqllib/lib |
Any suggestions, directions?
Hope you can help me.
Thank you.
_________________
Ing. José Luis Albor GarcÃa
IBM Certified System Administrator – WebSphere MQ V6.0
IBM Certified Solution Designer – WebSphere Message Broker V6.0 |
|
| Back to top |
|
 |
| Tibor |
| Posted: Mon Mar 12, 2007 1:15 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Mar 12, 2007 3:27 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Shoulnd't that be EnableSQLDescribeParam?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jlalbor |
| Posted: Mon Mar 12, 2007 8:20 am Post subject: |
|
|
Apprentice
Joined: 18 Feb 2003
Posts: 38
|
Hi Tibor, I cant not see why it could be a Page Conversion problem.
Could you explain please?
The Broker is running on AIX and the remote Oracle DB is also running on AIX.
Thanks.
_________________
Ing. José Luis Albor GarcÃa
IBM Certified System Administrator – WebSphere MQ V6.0
IBM Certified Solution Designer – WebSphere Message Broker V6.0 |
|
| Back to top |
|
|
| jlalbor |
| Posted: Mon Mar 12, 2007 8:30 am Post subject: |
|
|
Apprentice
Joined: 18 Feb 2003
Posts: 38
|
| jefflowrey wrote: |
| Shoulnd't that be EnableSQLDescribeParam? |
Hi jefflowrey,
Do you know how the EnableSQLDescribeParam parameter works?
I will set it to 0 and see what happens.
Thanks.
_________________
Ing. José Luis Albor GarcÃa
IBM Certified System Administrator – WebSphere MQ V6.0
IBM Certified Solution Designer – WebSphere Message Broker V6.0 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Mar 12, 2007 8:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
No, it needs to be enabled for Broker. Do not set it to 0.
You, however, had "EnableDescribeParam" in your ODBC datasource listing, and not "EnableSQLDescribeParam".
Maybe that was a typo.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jlalbor |
| Posted: Mon Mar 12, 2007 5:37 pm Post subject: |
|
|
Apprentice
Joined: 18 Feb 2003
Posts: 38
|
| jefflowrey wrote: |
No, it needs to be enabled for Broker. Do not set it to 0.
You, however, had "EnableDescribeParam" in your ODBC datasource listing, and not "EnableSQLDescribeParam".
Maybe that was a typo. |
Hi jefflowrey, I have edited the odbc.ini file adding the parameter EnableSQLDescribeParam=1 in the data source declaration, but the error is the same, [DataDirect][ODBC Oracle driver]Optional feature not implemented.
[MARCH]
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
Description=Oracle DB para marc huehuetoca
EnableSQLDescribeParam=1
EnableDescribeParam=1
OptimizePrepare=1
ServerName=march
WorkArounds=536870912
ProcedureRetResults=1
Thank you.
_________________
Ing. José Luis Albor GarcÃa
IBM Certified System Administrator – WebSphere MQ V6.0
IBM Certified Solution Designer – WebSphere Message Broker V6.0 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Mar 12, 2007 6:24 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Sorry. I was wrong, looking at the InfoCenter, which you should have been doing as well.
You need to modify
| Code: |
Driver=<Your_install_directory>/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=<Your Oracle host>
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1 |
To suit your environment.
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/topic/com.ibm.etools.mft.doc/ah14444_.htm
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
