本文详细介绍如何在Windows环境下通过ODBC数据源管理器设置Oracle 10g的ODBC数据源，包括选择适当的驱动程序、填写DSN名称和服务名等步骤，并提供注册表编辑指导。
这三天太郁闷了，一直想使用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.
扫一扫
718
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
