这三天太郁闷了,一直想使用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.
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.