| Author |
Message
|
| fjb_saper |
 Posted: Tue Nov 28, 2006 11:37 am Post subject: |
 |
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20767
Location: LI,NY
|
Looks like you are still over your head... Get an oracle admin to help you set it up right. ... 
_________________
MQ & Broker admin |
|
| Back to top |
|
 |
| JosephGramig |
| Posted: Tue Nov 28, 2006 2:43 pm Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
Did you install the Oracle client on the Broker machine?
Did you configure the Oracle client on the Broker machine?
Can you connect to the database with SQLPlus from the broker machine with the broker ID?
If not, do that can come back.
_________________
Joseph
Administrator - IBM WebSphere MQ (WMQ) V6.0, IBM WebSphere Message Broker (WMB) V6.1 & V6.0
Solution Designer - WMQ V6.0
Solution Developer - WMB V6.1 & V6.0, WMQ V5.3 |
|
| Back to top |
|
|
| Gemz |
| Posted: Tue May 13, 2008 6:01 am Post subject: |
|
|
Centurion
Joined: 14 Jan 2008
Posts: 124
|
Yes, I am using WMB in windows. I have created the DSN in control panel and configured mqsisetdbparms.
| Quote: |
| Is the Oracle 10g client you are using supported by the broker? check this out. |
How to check whether Oracle 10g is supported by broker? |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue May 13, 2008 6:10 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
|
| Back to top |
|
|
| dp111443 |
| Posted: Tue May 13, 2008 6:17 am Post subject: |
|
|
Voyager
Joined: 25 Feb 2004
Posts: 82
|
|
| Back to top |
|
|
| broker_new |
| Posted: Tue May 13, 2008 6:34 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
Follow these steps:
Oracle
When you define a data source for Oracle, choose the driver:
MQSeries DataDirect Technologies 5.00 32-BIT Oracle
The ODBC Oracle Driver Setup dialog opens.
Complete these steps to configure the driver:
On the General tab:
Enter the DSN name, description, and server name (where the server name is the "Service Name" that resolves to a "Connect Descriptor", for example through a mapping in the TSNAMES.ORA file).
Select the appropriate Oracle client version from the list.
On the Advanced tab:
Select Enable SQLDescribeParam.
Select Procedure Returns Results. The resultant ODBC definition in the Windows registry has a string value called ProcedureRetResults with the value 1.
Click Start > Run.
Type REGEDIT in the Open field.
Click OK.
Use REGEDIT to navigate to the correct location. Create a new registry subkey for each of your DSNs that reference an Oracle database.
HKEY_LOCAL_MACHINE
SOFTWARE
ODBC
ODBC.INIClick OK to close ODBC Data Source Administrator.
Right-click DSN. Select New > String Value.
Specify WorkArounds for the string.
Right-click WorkArounds.
Select Modify.
Type the data value 536870912.
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
|
|
