INF: DB2 ?? ??? Microsoft OLE DB ??????? ?? ??? ???? ????? ???????? ????

???? ?????? ???? ??????
???? ID: 218590
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

???? ???????

DB2 ?? ??? Microsoft OLE DB ??????? ?? ????????? ??????

??? OLE DB ???????? ????????? ?? ??? DB2 ?? ??? Microsoft OLE DB ??????? ?? ????? ????, ???? ?? ??;
  • Microsoft ???? ???? ????? (UDL) ?????, ?? ???? ????????? ?? ??? ?????

    -??-
  • ??????? ???????? ?? ?????? ??????? ??? ?? ????? ???? ??? ??????? ?? ??? ?????
Microsoft ???? ?????? ????? (MDAC) 2.0 ?? ??? ??? ????? ???? ??????, ?? ??????? ?? OLE DB ???? ??????? ?? ??????? ?? ??? ???? ?? ??? ?? ??????? ?????? ??? ???? ???? ?????? ?? OLE DB ???? ??????? ?? ??? ??????? ??????? ???? ???? ?? ?? ?????? ????? UDLs, ??? ?? ??????? OLE DB ??????? ??? ?? ADO ??????? ???????? ?????? ?? ???? ?? ????? ???? ?? ???????? ??????? ?? ??? ?????? SNA ????? SDK ?????????? ??? "????? OLE DB ??????? ?? ??? DB2" ??????

OLE DB ???? ????

???? ???????? ????? ???? ????? ???????? ?? ??? DB2 ?? ??? OLE DB ??????? ?? ????? ???? ??? ?? ?????? ?? ???? ?? ?? ???? ????? ??????? ?? ????????? ???? ?????? OLE DB ??????? DB2 ?? ??? ?? ??? ??????? ???????? ???? ???? ????? ?? ??? ????? ???? ???? ??, ?? ???????? ???? ??? ???????? ???? ????? ?? ??? ???-??? ???? ?? ??? ?? ???????? ?? ???????? ??? ???? ???? ????? ?? ??? OLE DB ???? ????? ????-??????? ???????? ????????? UDL ??????? ?? ??? ??? ?????????? ?????? ?? ?????? ????? ??? ?????????, SNA ????? SDK ?? ??? ????? RowsetViewer ????? ??? ???? ??? ???? UDL ?????? ???? ?? ??? ???????? ????????????? ???????? OLE DB ??????? ?? ??? DB2 ?? ??? ????? ????

??? ?? ???? ???? ???? ?? ???????? ????

You must create a Data Link to configure parameters for your OLE DB data source. You can create a new Data Link by clicking the shortcut in the SNA Server\Data Access program folder. The properties of a Data Links file can be edited by opening the file from Windows Explorer. To edit the data links file:

Windows NT ?? ???

  1. From the Start menu, select the Microsoft SNA Server program group.
  2. Select the Data Access program group.
  3. Select New OLE DB Data Source. TheData Link Propertiespage appears.
  4. Configure the data source information for the selected provider. ????? ????,??????? ??????? ?? ????
  5. ????? ????,OKto save the Data Link.

For Windows 95/98

  1. From the Start menu, select the Microsoft SNA Server program group.
  2. Select the Data Access program group.
  3. Select New OLE DB Data Source. TheData Link Propertiespage appears.
  4. Configure the data source information for the selected provider. ????? ????,??????? ??????? ?? ????
  5. ????? ????,OKto save the Data Link.
By default, Data Links are created in the Program Files\Common Files\System\OLE DB\Data Links folder. However, you can create a Data Link in any location by opening the target folder, selectingNew Microsoft Data Link??????menu, and configuring theData Link Properties??????

Browsing OLE DB Data Sources

By default, Data Links are created in the Program Files\Common Files\System\OLE DB\Data Links folder. A shortcut is provided in the Microsoft SNA Server program group. To browse the data sources:
  1. From the Start menu, select the Microsoft SNA Server program group.
  2. Select the Data Access program group.
  3. Select Browse OLE DB Data Source. The list of data links saved in the default location is displayed.

Configuring OLE DB Data Source for DB2 using Data Links

TheProvidertab allows the user to select the OLE DB provider (the provider name string) to be used in this UDL file from a list of possible OLE DB providers. ?????Microsoft OLE DB Provider for DB2.

The???????tab allows the user to configure the basic properties required to connect to a data source. For OLE DB Provider for DB2, the connection properties include the following values:

Data Source: The data source is an optional parameter that can be used to describe the data source. ?? ???? ???? ??????????? ????????? SNA ????? ????????? ?????? ?? ??? ?????? ?????????? ?????? ??? ?? ????? ?? ??? UDL ?????, ?? ????????? Files\Common Files\System\OLE DB\Data ?????????? ??? ???????? ???? ?? ??? ????? ???? ???? ???

?????????? ???: ????? ?????????? ??? ?? ??????? ??? ?? DB2 ?? ???? ?? ??????? ?? ??? ?????? ??? ?? ??? ???????? ??? ??, ?? ?? ???? ??? ???? ???? ???? ??? ??? ?????????? ???? OLE DB ??????? ?????? ??? ?????????? ??? ????? ??????? ???? ???? ?? ??? ????? ?? ????? ???? ??? ??, ????? ????? ????? ?????????? ???? ???? ??? ???????? ?????????? ??? ?? ???????? ???? ?? ??? ?????? ?????

??????? / 400 ???????? ?? ??? regard ?????????? ID ?? ???? ?? ??? ??????? ???-?????? ??? ??????? / 400 ???? ??????? DB2/400 ?????????? ID ?? ?? ???? ?????? ??? ???????? (??? DB2/400 ??????? ?? ???? ??? ??????? ???? ???? ??, OLE DB ??????? ????? re-send ???????, ??????? ?? ?????????? ID ???? ?? ????? ??? ??.)

Mainframe case-insensitive ??? ???? ???? ?? ?? ?? mainframe ?????????? ??, ?? ?? ???? ??? DB2 ?????????? ID ?? ??????? ???? ???? ??? ?????? ???? OLE DB ??????? ???? ?????? ??? ?? ????? ????? ???????

Windows NT ?? ??? DB2 UDB ???-?????? ??? ?????????? ID ???? ?????? ??? ???????? ???? ????? ??????? ?? ????-???? ?????? ??? ???????? ??? ?????????? ??? ?????? ??? ??????? ???? ???? ?????? ??? OLE DB ??????? ?????????? ?????? ???? ?? ?????? ??? ??????? ??? ?? ??????? ????? ??? ?????????? ????? ????? ?? ??? ???? ?? Windows NT ????? ??? ?? ??? Windows NT ?????????? ????

???????: ??? ????? ??????? DB2 ?? ???? ?? ??????? ?? ??? ??????? ??? ?? ?????? ??? ???????? ??? ??, ?? ??? ???? ??????? ?? ??? ?? UDL ???? ??? ?????? ?? ?????????? ?????? ?? ?????? ?????? ?????.

???????:: ?? ?????? ?? ?????????? ??????? ?? ???? ??? ??? UDL ????? ??? ??? ???? ???

????????? ??????: OLE DB ??? ?? ?? ??? ??? ???? ??? ??????????? ?????? ??? ?? ???? ??? ?? ??? ??? ????? ???? ???? ???

DB2 ??? (MVS, OS/390), ?? ??? ?? ???????? ???? ?? ??? ????? ?? ??? ???? SYSIBM.LOCATIONS ?????? ????? ????? ??????? ?? ???? ???? ???? ??? To find the location of the DB2 to which you need to connect, ask your administrator to look in the TSO Clist DSNTINST under the DDF definitions. These definitions are provided in the DSNTIPR panel in the DB2 installation manual.

In DB2/400, this property is referred to as RDBNAM. The RDBNAM value can be determined by invoking the WRKRDBDIRE command from the console to the OS/400 system. If there is no RDBNAM value, then one can be created using theadd???????

In DB2 Universal Database, this property is referred to as DATABASE.
The???????tab also includes aTest Connectionbutton that can be used to test the connection parameters. The connection can only be tested after all of the required parameters are entered. When you click this button, a session is established to the remote DB2 system using OLE DB Provider for DB2.

The???tab allows the user to configure additional properties used to connect to a data source. Some of the properties in the???tab are required. These properties may be edited by selecting a property from the displayed list and selecting??? ?? ??????? ????. For Microsoft OLE DB Provider for DB2, these properties include the following values:
???????? TP ???: ?? ??? ???? ?? (DB2/VM ?? DB2/VSE), SQL/DS ?? ?????? ???? ??? ?? ???????? ?? ????????? ?? ?????? ????????? ?? ??? ??? ??? ???????? ???

APPC ??????? LU ?????: SNA ????? ??? ???????? ???? ??? ??????? LU ????? ?? ??? ???

APPC ??? ???: APPC ??? ?? ????? ??????????? ?? SNA ????? ??????????? ?? ??? ???? ??? APPC ??? ?? ??? ?????? ??? ????? QPCSUPP (??????? ?????? ???????), #INTER (??????), #INTERSC (??????? ??????? ?????? ?? ??? ????????), #BATCH (???), #BATCHSC (??????? ??????? ?????? ?? ??? ???) ?? #IBMRDB (DB2 ??????? ?? ?????? ?????)?

APPC ?????? LU ?????: SNA ????? ??? ???????? ???? ??? ?????? LU ????? ?? ??? ???

????: ???? ???: ??? SQL ??? ?? implicit COMMIT ?? ??? ??? ?? ???? ??? ????? ???? ??? ???, ???????? ??????? ???????? ?? ??? ????????? ?? ?? ???? ??? ?? ??? ???? ??? SQL ??? ?? ??? ??????? ????????? ?? ??? ??????? ??? ???????? delimit ?? ?? ????????? ?? ?????? ????????? ???? ?? ??? ??? ??? ?????? ????? ???? ??? ?? ????? ???? ??? ?? ?????? ??? ??????? ?? ??? ???

??? ???????: ??????? ???? ????? ???????? ?? ?????????? ????????? ?????????? ???????, ???? ?? ???? ?????? ??? ??? ??? ??????? ??? ???? ?? ?????? ??? ??????? ?? false ???

??????? Isolation ????: ?? isolation DB2 ???????? ?? ????? simultaneous ?? ?????? ??? ???? ??????????? ?????? ????? ?? ???? ?? ????????? ???? ??? ??????? ?? NC ??? ????? ???? ??????? ???:
CS   Cursor Stability. 
     In DB2/400, this corresponds to COMMIT(*CS). 
     In ANSI, this corresponds to Read Committed (RC).

NC   No Commit. 
     In DB2/400, this corresponds to COMMIT(*NONE). 
     In ANSI, this corresponds to No Commit (NC).

UR   Uncommitted Read. 
     In DB2/400, this corresponds to COMMIT(*CHG). 
     In ANSI, this corresponds to Read Uncommitted. 

RS   Read Stability. 
     In DB2/400, this corresponds to COMMIT(*ALL). 
     In ANSI, this corresponds to Repeatable Read.

RR   Repeatable Read. 
     In DB2/400, this corresponds to COMMIT(*RR). 
     In ANSI, this corresponds to Serializable (Isolated).
					
??????? ??????: ???? ??????? ????? ?????? ??????? ?????? ?? ??? ??? OLE DB ??????? ?????? ??? ?? ???????? ????????, ???? ??? ?????? ?????? (?????? ?? ???, OLE DB IDBSchemaRowset DBSCHEMA_TABLES) ??? ???????? ?? ???? ?? ???? ?? ??? ?? ?? ??? ?????????? ???? ?? ??? ??????? ?????? ?? ????? ???? ??? ??? ??, OLE DB ??????? ????? ??????? ?????? IOpenRowset::OpenRowset ?????? ?? ??? ???? SQL SELECT ??? ?????? ?????? ?? ??????? ?? ???????? ??????? ?? ??? ????? ????? ???? ?? Microsoft ???????? ??? ????? ?????:
217757INF: ????? ?? ??? ODBC ??????? ?? ??? DB2 ?? OLE DB ??????? ?? ??? DB2 ?? ??? ???????? ??????
????????? ???: ???? ???? ???????? ???????-??????? ????? ?? ????????? ???? ?? ???? ?? ???????? ?????? ???? ??? ??? ???????? ??????????? ?? ???? ?????, ?? ?????????? ??????? ??????? ??????? ?? ?????? ???? ??????

????? CCSID: ???? ??? ??? ?????????? (CCSID) DB2 ???? ?? ??? ???? ?? ??? ??? ?????? ???????? ?? ???????? ???? ???? ??? ?? ???????? defaults U.S./Canada (37) ?? ??? ??? ???? ???? ?? ??? ??? ??????? ???? ??????? ???? ??? CCSID ??? ?????? ??? ?? ?? ?????? ?? ??? ??? ??????? ????????? ?? ??? ??, ???? ??? ?????? ???? ?? DB2 ????? CCSID ?? ??????? ANSI ??? ????? ?? ?????? ???

??????? ???: ?????? DB2 ????????, ????? ??? ?? TCP/IP ??? ?? ???? TCP/IP ????? ???/??? DRDA ????? ?? ??????? ?????? ?? ??? ?? ??? ?? ????? ???? ???? ??? TCP/IP ?? means ?????? ?????? ???? ??? ??????? ??? ?????? ???

??????? ?????: TCP/IP ?? means ?????? ?????? ???? ??? ?????? DB2 DRDA ???? ?? ????? ????? ?? ?????? ?? ??? ?? ??? ?? ????? ???? ???? ??? ??????? 446 ?? ???????? DRDA ????? ??? ???

??????? ??????????? ?????????: ??????? ?????? means ?? SNA LU6.2 ?? TCP/IP ?? ?????? ???? ?? ?? ???? ??????? ??????? ???????? ???? ????????? ??? designates. ??????? ??? ?? SNA ??? ??? TCP/IP ????? ??, ?? ????? ?? ?????????? ???, ????????? ??????????? ???? ??? ??? ??????? SNA ????? ??, ?? ????? ?? ???APPC ??????? LU ?????,APPC ??? ???, ??APPC ?????? LU ??????????? ????

????? ??????: DRDA ?????? ?? ???? ?? ?? ????? ??? ?????? ?? DB2 ????? ?? ????? ???? ?? ??? ??????? ?? ??? ??? ?? ??????? ?????? ?? ??? ??? ?? ?? ?? ????? ?? ?????? ???????? ??? ???????? ??????? ?? ???, ????? ????? ???? ?? Microsoft ???????? ??? ????? ?????:
216810DB2 ?? DB2 ?? ??? OLE DB ??????? ?? ??? ODBC ??????? ?? ??? ????? ?? ??? ????? ??? ??? ??
PC ??? ?????: ???? ???? ?? ??? ??? ??????? ???? ??????? ???? ??? ?? ??? ?????? ??? ?? ?? ?????? ?? ??? ??? ??????? ????????? ?? ??? ??, ???? ??? ?????? ???? ?? Windows ??? ???????? ???? ??? ??????? ANSI ??? ??? ?? ?????? ??? ?? ??? ?? ??? ??????? ??? ?? (1252) ????? 1 ???

??????? ??????? ?? ??? ???? ??: ???????? ??? ??, ?? ??? ???? ??????? ?? ??? ?? UDL ???? ??? ?????? ?? ?????????? ?????? ?? ?????? ?????? ?????.

???????:: ?? ?????? ?? ?????????? ??????? ?? ???? ??? ??? UDL ????? ??? ??? ???? ???

???? ?? ??? ??? ??????? ??????: This option treats binary (CCSID 65535) data type fields as character data type fields on a per-data source basis. TheHost CCSID, ??PC Code Page values are required input and output parameters.

???? ?????: Creates a read-only data source. The user has read-only access to objects, such as tables, and cannot do update operations, such as INSERT, UPDATE, or DELETE.

??????

???

???? ID: 218590 - ????? ???????: 03 ?????? 2010 - ??????: 2.0
??????: 
kbinfo kbmt KB218590 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:218590

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com