PRB: Phn b? truy v?n tr? v? l?i 7356 v?i MSDAORA

D?ch tiu ? D?ch tiu ?
ID c?a bi: 251238 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

? Trang ny

TRI?U CH?NG

N?u thng tin siu d? li?u thay ?i ? th?i gian th?c hi?n, l?i sau x?y ra:
My ch?: Msg 7356, c?p 16, bang 1, d?ng 1
OLE DB nh cung c?p 'msdaora' cung c?p siu d? li?u khng ph h?p cho m?t c?t.
L?i ny c th? x?y ra khi b?n s? d?ng phn ph?i truy v?n trong SQL Server tham kh?o m?t ci nh?n n?u b?n t?o n?m bn d?i b?ng trong Oracle theo cc i?u ki?n sau y:
  • B?n khng ch? ?nh Nullability trong tuyn b? t?o b?ng. - v -

  • B?n t?o m?t kha chnh b?ng cch s? d?ng cc bo co thay ?i b?ng - v -

  • B?n t?o ra m?t ci nh?n bao g?m cc kha chnh.

NGUYN NHN

IDBSchemaRowset::GetRowset cho DBSCHEMA_COLUMNS tr? v? IS_NULLABLE nh l ng s? th?t.

IColumnsInfo::GetColumnInfo trn rowset tr? v? DBCOLUMNFLAGS_ISNULL nh l sai.

V? s? cc ny khc bi?t, phn ph?i truy v?n th?t b?i v?i l?i 7356.

Cc nh cung c?p OLE DB, Msdaora.dll, tr? v? cc thng tin sai b?i v? cc siu d? li?u Oracle tr? v? l khng chnh xc.

GI?I PHP

Ch? ?nh Nullability c?a c?t m?t cch r? rng trong cc bo co t?o b?ng.

T?NH TR?NG

Hnh vi ny l do thi?t k?.

THNG TIN THM

Cc b?c ? t?o l?i hnh vi

S? d?ng cc b?c sau ? t?o l?i hnh vi:
  1. T?o b?ng ki?m tra b?ng cch s? d?ng m? ny:
    CREATE TABLE MYDIST
          (GMI_ID  VARCHAR2(8)
          ,LAST_NAME VARCHAR2(20)
          ,FIRST_NAME VARCHAR2(20) )
    					
  2. Thay ?i b?ng b?ng cch s? d?ng m? ny:
       ALTER TABLE MYDIST
          ADD (CONSTRAINT MYDIST_PK PRIMARY KEY (GMI_ID))
    					
  3. Chn d? li?u vo b?ng b?ng cch s? d?ng m? ny:
       INSERT INTO MYDIST VALUES ('test1','row','one')
       INSERT INTO MYDIST VALUES ('test2','row','two')
    					
  4. T?o ra m?t s? d?ng ny:
       CREATE VIEW V_MYDIST1 AS
          SELECT GMI_ID FROM MYDIST
    					
  5. T?o m?t m?c my ch? ?c lin k?t b?ng cch s? d?ng cc t?p tin msdaora.dll v th?c thi truy v?n sau y:
    select * from <OracleLinkedServer>..<SchemaName>.V_MYDIST1
    					
    Truy v?n tr? v? l?i ny:
    My ch?: Msg 7356, c?p 16, bang 1, d?ng 1
    OLE DB nh cung c?p 'msdaora' cung c?p siu d? li?u khng ph h?p cho m?t c?t. Siu d? li?u thng tin ? ?c thay ?i ? th?i gian th?c hi?n.

Thu?c tnh

ID c?a bi: 251238 - L?n xem xt sau cng: 21 Thang Tam 2011 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 7.0 Standard Edition
T? kha:
kbmdacnosweep kboracle kbprb kbmt KB251238 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:251238

Cung cp Phan hi

 

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