PRB: ??????? ??? ????? ????????? 7356 ?? MSDAORA

?????? ????????? ?????? ?????????
???? ???????: 251238 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ???? ??????? ?????? ????? ?? ??? ????? ???? ????? ??????:
????: ????? 7356 ? ????? 16 ???? 1? ????? 1
???? OLE DB 'MSDAORA' ????? ?????? ??????? ??? ??????? ?????.
?? ???? ??? ????? ??? ??????? ????????? ??????? ?? ???? SQL ???? ???? ??? ????? ??? ??? ??? ?????? ?????? ??????? ?? Oracle ??????? ???????:
  • ?? ??? ?????? Nullability ?? ????? CREATE TABLE. - ? -

  • ????? "????? ?????" ???????? ????? ALTER TABLE - ? -

  • ????? ????? ??? ????? PRIMARY KEY.

?????

????? IDBSchemaRowset::GetRowset ?? DBSCHEMA_COLUMNS IS_NULLABLE ?? TRUE.

????? IColumnsInfo::GetColumnInfo ??? ?????? ?????? DBCOLUMNFLAGS_ISNULL ?? FALSE.

????? ??? ????????? ????????? ??????? ????? ?? ????? 7356.

???? OLE DB Msdaora.dll ? ?????? ????????? ??? ???? ??? ?????? ??????? ???? ???? Oracle ??? ????.

????

????? Nullability ?????? ???? ???? ????? ????? CREATE TABLE.

?????

????? ??? ?????? ??? ???????.

??????? ????

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

?????? ??? ??????? ?????? ????? ??????:
  1. ????? ???? ???????? ???????? ??? ???????? ????????:
    CREATE TABLE MYDIST
          (GMI_ID  VARCHAR2(8)
          ,LAST_NAME VARCHAR2(20)
          ,FIRST_NAME VARCHAR2(20) )
    					
  2. ???? ???????? ??? ???????? ????????:
       ALTER TABLE MYDIST
          ADD (CONSTRAINT MYDIST_PK PRIMARY KEY (GMI_ID))
    					
  3. ????? ?????? ?? ?????? ???????? ??? ???????? ????????:
       INSERT INTO MYDIST VALUES ('test1','row','one')
       INSERT INTO MYDIST VALUES ('test2','row','two')
    					
  4. ????? ????? ??? ??????? ???:
       CREATE VIEW V_MYDIST1 AS
          SELECT GMI_ID FROM MYDIST
    					
  5. ????? ????? ???? ????? ???????? ??? msdaora.dll ?????? ????????? ??????:
    select * from <OracleLinkedServer>..<SchemaName>.V_MYDIST1
    					
    ????????? ????? ??? ?????:
    ????: ????? 7356 ? ????? 16 ???? 1? ????? 1
    ???? OLE DB 'MSDAORA' ????? ?????? ??????? ??? ??????? ?????. ?? ????? ??????? ?????? ????? ?? ??? ???????.

???????

???? ???????: 251238 - ????? ??? ??????: 26/????? ??????/1425 - ??????: 3.2
????? ???
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 7.0 Service Pack 1
????? ??????: 
kbmt kbmdacnosweep kboracle kbprb KB251238 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????251238

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

 

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