| Author |
Message
|
| fmottais |
 Posted: Wed May 30, 2007 6:25 am Post subject: Ressource ODBC ORACLE ESQL in PROCESSFLOW WMB6.0.3 |
 |
|
Novice
Joined: 30 May 2007
Posts: 10
|
Hello,
I have created a ressource ODBC Oracle 10g in the odbc.ini which is good when i test whith odbctest RessourceName user password.
In my node ESQL i put the resource ODBC's name, where i can put the user and password ? i try to put in the odnbc.in LogonId and password but it doesn't work.
The resuls is ORA-1017 the user/password is invalid
Where i can put this parameters ? what are the solutions?
Thanks |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed May 30, 2007 6:26 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
mqsisetdbparms
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| fmottais |
| Posted: Wed May 30, 2007 8:25 am Post subject: |
|
|
Novice
Joined: 30 May 2007
Posts: 10
|
thanks,
for unix it is good, but for windows, i have this error
Text = [Oracle][ODBC]Optional feature not implemented.
Have you an idea? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed May 30, 2007 8:26 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You're using the wrong driver for Oracle.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| fmottais |
| Posted: Wed May 30, 2007 11:55 pm Post subject: |
|
|
Novice
Joined: 30 May 2007
Posts: 10
|
i have tried 3 drivers, but it's doesn't work :
MQSERIES Datadirect technologie 5.0 32 bit Oracle version 5.00.00.105
ORaclient10g_home version 10.02.00.01
Microsoft ODBC for Oracle 2.576.1830.00
Do you know a driver which work?
Tjhanks |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu May 31, 2007 12:00 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi fmottais,
| fmottais wrote: |
Text = [Oracle][ODBC]Optional feature not implemented.
Have you an idea? |
Where are u getting this error....I remember getting the same a few weeks back for an interface using Db commands, maybe for not the same reasons, but if you could tell where it occurs, you could help me remember why and how I resolved it.
Regards. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu May 31, 2007 3:29 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| fmottais wrote: |
| MQSERIES Datadirect technologie 5.0 32 bit Oracle version 5.00.00.105 |
This is the only one to use.
Make sure you have checked EnableDescribeSQLParam.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| fmottais |
| Posted: Thu May 31, 2007 3:59 am Post subject: |
|
|
Novice
Joined: 30 May 2007
Posts: 10
|
| Thanks, it's good with the driver MQseries DataDirect ... and the option Enable SQLDescibeParam must be checked. |
|
| Back to top |
|
|
|
|
