| Author |
Message
|
| mqwbiwf |
 Posted: Wed Dec 19, 2007 9:02 am Post subject: oracle driver error? |
 |
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
hi,
when we run a test message across one of our message flows deployed to the version 6.0 broker CSD 3 on AIX, we get a weird error of:
'[DataDirect][ODBC Oracle driver]Optional feature not implemented'.
it's an oracle db that the broker is trying to connect to.
infact the same database is being used as a broker database as well, and we never had issues with broker. it's only with a few msg flows that we see this driver issue.
The driver presently being used is:
Driver=<install directory>/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
I tried to search the forum, but nost of them say to use DataDirect drivers instead of oracledrivers, which is what we are using but still see those errors.
could someone shed some light on what the issue might be? |
|
| Back to top |
|
 |
| mqwbiwf |
| Posted: Wed Dec 19, 2007 9:20 pm Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
| Guys, Any thoughts on this? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Dec 20, 2007 4:05 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There was another thread two or three days ago with a similar problem.
Confirm all of your ODBC settings, including workarounds value.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Mon Jan 07, 2008 1:18 pm Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
hi guys, after going through this site and a few others from google, we added a couple of lines to odbc.ini file (in bold):
[YYYYY]
Driver=/install-dir/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
EnableSQLDescribeParam=1
OptimizePrepare=1
ServerName=XXXXX
WorkArounds=536870912
WorkArounds2=2
ProcedureRetResults=1
ColumnSizeAsCharacter=1
but unfortunately haven't had any luck so far... 
any help is greatly appreciated. |
|
| Back to top |
|
|
| VivekMeshram |
| Posted: Mon Jan 07, 2008 4:36 pm Post subject: |
|
|
Voyager
Joined: 25 Mar 2002
Posts: 83
|
Hi,
All parameters seems to be fine except as I believe the Description field should be = Oracle8. Not too sure whether Description field = DataDirect 5.0 Oracle should work or not? Can you try as per following?
[YYYYDB]
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=XXXXX
EnableDescribeParam=1
OptimizePrepare=1 |
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Mon Jan 07, 2008 8:32 pm Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
| But isn't that just a comment kind of line, the 'Description' line? |
|
| Back to top |
|
|
| VivekMeshram |
| Posted: Mon Jan 07, 2008 10:21 pm Post subject: |
|
|
Voyager
Joined: 25 Mar 2002
Posts: 83
|
Yes! You are correct, this is a text field for only information and has no bearing on operation. Can you try adding following parameter as well and see whether this helps you
SelectUserName=1 |
|
| Back to top |
|
|
| samar14 |
| Posted: Wed Jan 09, 2008 3:05 am Post subject: |
|
|
Novice
Joined: 30 Nov 2007
Posts: 17
|
The error '[DataDirect][ODBC Oracle driver]Optional feature
not implemented.' comes from the DataDirect Oracle driver.
It is to inform that that the drivers do not support the
feature of oracle which is being attempted .
you will need to identify the database operation in ESQL which
causes this error and see if that is supported by Oracle drivers
from DataDirect. |
|
| Back to top |
|
|
|
|
