| Author |
Message
|
| ferquirino |
 Posted: Wed Sep 14, 2011 10:38 am Post subject: WMB 6.1.0.5 and Oracle Client 11g (ODBC) |
 |
|
Apprentice
Joined: 05 May 2008
Posts: 34
Location: São Paulo, Brazil
|
Hello,
After many month, I came back to Broker.
And early on I encounter a problem.
WBM 6.1.0.5 (tha same of customer), client Oracle 11g and Windows XP.
I try create a connection ODBC to Oracle.
When I try test connection appar the follow messagem
The message is in portuguese. I'm going trying translate.
"odbcad32.exe - entry point not found"
"Couldn't find the entry point of the procedure GetProcessImageFileNameA in the dynamic link library PSAPI.dll"
I needed of google to translate.
Has anyone had this problem or want help me?
Thanks in advance. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Sep 14, 2011 10:43 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You must use the DataDirect ODBC driver with Oracle11g and Message Broker.
You can not use the Oracle ODBC Driver.
So please make sure that your ODBC DSN is properly using the DataDirect driver. |
|
| Back to top |
|
|
| ferquirino |
| Posted: Wed Sep 14, 2011 10:53 am Post subject: |
|
|
Apprentice
Joined: 05 May 2008
Posts: 34
Location: São Paulo, Brazil
|
Hello mqjeff
Thanks for answer.
Yes, I'm using DataDirect ODBC.
I didn't get to do at the mqsisetdbparms yet.
Before, I tried use test connection of windows and after put user and password, appear this error.
I tried to connect the same pc with SQL Developer, connection was successful.
Thanks in advance. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Sep 14, 2011 10:57 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| You may need to upgrade to a newer level of Broker 6.1 to support Oracle 11g. |
|
| Back to top |
|
|
| ferquirino |
| Posted: Wed Sep 14, 2011 11:20 am Post subject: |
|
|
Apprentice
Joined: 05 May 2008
Posts: 34
Location: São Paulo, Brazil
|
Thanks mqjeff.
I'll try 6.1.0.9.
I also need to confirm the version of Oracle client and continue with the fix. Then come back to talk about the results.
Thanks. |
|
| Back to top |
|
|
| joemq |
| Posted: Fri May 18, 2012 9:03 am Post subject: WMB 6.1.0.5 and Oracle Client 11g (ODBC) |
|
|
Novice
Joined: 18 May 2012
Posts: 10
|
| I am also getting same error when i am connecting to oracle database and my broker version is 6.1.0.8. Are you able to connect now after updating the version to 6.1.0.9. |
|
| Back to top |
|
|
|
|
