MB连接Oracle数据库 郁闷的事情

这三天太郁闷了，一直想使用MB连接oracle10g,但一点进展也没有，看到了IBM上的infocenter,仍然难以成功。

Configure an ODBC data source using the ODBC Data Source Administrator:
Click Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
Click the System DSN tab.
When you define a new data source, select the appropriate driver for your database and complete the dialog that is displayed. Refer to your relevant database product documentation for more information.


The Default Configuration wizard and the database commands to create a broker, or a database, on Windows automatically create the ODBC data source names (DSNs) for you.
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.INI
Click 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.

You have now configured your ODBC data source names on Windows.

评论

1 楼 excuse 2009-09-16  

需要两步设置：
0.前提，你的ORACLE客户端已安装在服务器上
1.配置系统DSN时选择 MQSeries DataDirect Technologies 5.00 32-BIT Oracle 作为oracle的驱动，修改注册表，按infocenter中所讲，添加WorkArounds

2.同时，在MB命令行控制台上，执行下列语句
>mqsisetdbparms BROKER代理名 -n ORACLEDBoracleODBC名 -u 用户名 -p 密码