应该是ODBC设置的问题,你要按照infocenter上的介绍完整配置。Oracle Define a data source for Oracle:1.◦If you are using WebSphere Message Broker for Windows 32-bit , select the driver WebSphere Message Broker DataDirect Technologies 6.0 32-BIT Oracle Wir...显示全部
应该是ODBC设置的问题,你要按照infocenter上的介绍完整配置。
Oracle
Define a data source for Oracle:
1.
◦If you are using WebSphere Message Broker for Windows 32-bit , select the driver WebSphere Message Broker DataDirect Technologies 6.0 32-BIT Oracle Wire Protocol.
◦If you are using WebSphere Message Broker for Windows 64-bit , select the driver WebSphere Message Broker DataDirect Technologies 6.0 64-BIT Oracle Wire Protocol.
The ODBC Oracle Driver Setup dialog box opens.
2.On the General tab:
a.Enter the DSN name, description, and host name of the machine where Oracle is running, the port number on which Oracle is listening, and the Oracle SID that you want to connect to.
3.On the Advanced tab:
a.Select Enable SQLDescribeParam.
b.Select Procedure Returns Results. The resultant ODBC definition in the Windows registry has a string value called ProcedureRetResults with the value 1.
c.Select Login Timeout and set the value to 0.
4.Click OK to close the ODBC Data Source Administrator.
5.Click Start > Run.
6.Type REGEDIT in the Open field and click OK.
7.In the Registry Editor, navigate to the correct location.
◦If you are using WebSphere Message Broker for Windows 32-bit on Windows 32-bit editions: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
◦If you are using WebSphere Message Broker for Windows 32-bit on Windows 64-bit editions: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI
◦If you are using WebSphere Message Broker for Windows 64-bit on Windows 64-bit editions: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
8.Expand that location, and right-click your DSN entry. Select New > String Value.
9.Specify WorkArounds for the string name.
a.Right-click WorkArounds.
b.Select Modify.
c.Type the data value 536870912.
10.Close the Registry Editor.收起