FIX: IN ? ?????? UNION ????? "??? ??????? ??? ????

?????? ????????? ?????? ?????????
???? ???????: 283842 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

?? ???? Microsoft OLE DB ?? Oracle (MSDAORA) ? ?? ???? ?? ????? ????? SQL ???? ????? ??? ?? ?? IN ? ????? UNION ???? Recordset ?????? ?????? ActiveX (ADO) ????? ??? ??? ??? ???? ?? ?????.

???? ??? ??????? ??? ??????? ???? ?????? ADO (??? ???? ??? ?? ????? ??????? CursorLocation ??? adUseClient) ???? ???? ???? ??? ??????? ???? ?? ???? ??????.

????

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? Microsoft MDAC 2.5. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
293312INFO: ????? ?????? ??? ???? MDAC 2.5 ???? ???????
??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? Microsoft ?????? Access ?????? 2.6. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
300635INFO: ????? ?????? ??? ???? MDAC 2.6 ???? ???????

?????????

??? ?? ???? ?????? ?????????? ?? ??? ??????? ???? ??????? ??????? ?? ????:
   Version       Size      File name     Platform
   -------------------------------------------------------
   2.53.6007.0   209,168   Msdaora.dll   x86
				

???? ??????

?? ???? ??????? ?? ???? ??????? ???? ?? ???? ??????; ?? ????? ??????? CursorLocation ??? adUseServer.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????. ?? ????? ??? ??????? ???? ??? ?? Microsoft ?????? Access ?????? 2.6 ?????? ????? ?????? Service Pack 2 ? MDAC 2.5 SP3 MDAC 2.7.

??????? ????

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

  1. ?? ?????? ????????? ???????? ??????? ?? ????? Visual Basic ???? ?????? ???? Project ??? ????? 2.5 ?????? ?????? ActiveX Microsoft:
    Private Sub Command1_Click()
    
        Dim cn As New ADODB.Connection
        Dim rs As New ADODB.Recordset
        cn.Open "Provider=MSDAORA;Data Source=your_oracle_server;User ID=your_user_name;Password=your_password"
        On Error Resume Next
        cn.Execute "Drop table oratest"
        cn.Execute "CREATE TABLE ORATEST(Col1 VARCHAR2(10) NULL," & _
                   "Col2 VARCHAR2(10) NULL)"
        cn.Execute "insert into oratest values(7,7)"
        cn.Execute " insert into oratest values(6,6)"
        cn.Execute "Drop table DUAL"
        cn.Execute "CREATE TABLE DUAL(C11 VARCHAR2(10) NULL," & _
                   "C12 VARCHAR2(10) NULL)"
        cn.Execute "insert into dual values(6,7)"
        rs.CursorLocation = adUseClient
        rs.Open "select col1, col2 from oratest where col1 in (Select C11 from dual union select C12 from dual)", _
                cn, adOpenStatic,adLockBatchOptimistic
        
        Debug.Print rs.Fields.Count      '<--- incorrect column count       
        Debug.Print rs.Fields(0).Name
        Debug.Print rs.Fields(1).Name
    End Sub
    					
  2. ??? ????? ??????? ????? ??? ??? ??? ??? ???? ?? ?????. ?? ??? ????? ????? "???? ?? ???" ???????? ??? ?????? ?????? ??????? ?? ???? Watch Visual Basic. ?? ??? ??????? ??? "Debug.Print rs.Fields.Count" ??? ????? ??? ??????? ?? ?????? ??????.

???????

???? ???????: 283842 - ????? ??? ??????: 09/???? ?????/1427 - ??????: 6.1
????? ???
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.5 Service Pack 1
  • Microsoft Data Access Components 2.6
????? ??????: 
kbmt kbqfe kbhotfixserver kbmdac250sp3fix kbbug kbfix kbmdac260sp2fix kboracle kbprovider KB283842 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????283842

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

 

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