FIX: ????? ODBC Microsoft ?? Oracle ??? ??????? ??? ?????? ?????? ?? ??? ??????

?????? ????????? ?????? ?????????
???? ???????: 292604 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ??????? ???? ?? ???? ?????? ????? Oracle ????? ???????? ?? ?????? ????? ODBC Microsoft Oracle ????? ???? ??? ??????? ????? ????? ????? ???????:
0x80004005 ("?????? ??????? ??? ????? ??????? ????? ?? ?????")
???? ??? ????? SQL SELECT ????? ???? WHERE ???? ????? ??? ??? ?????. ???? ??????? ??? ?? ???? ?? ???? ?????? ????? ???????? ?? ??? ???? WHERE ?? ?????? ??????? ?? ????? ??????? ????? ????? ??? ?????.

?????

??? ????? ????? ??????? ???? ?????? ???? ?????? ?????? ActiveX (ADO) ? ?? ???? ????? ?????? ???????.

????

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? Microsoft MDAC 2.5. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
293312INFO: ????? ?????? ??? ???? MDAC 2.5 ???? ???????
????? ????? ?????????? ?? ??? ??????? ???? ????? (?? ??????) ???????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ???????? ??????? coordinated (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
   Date         Version       Size     File name     Platform
   ----------------------------------------------------------------
   03-07-2001   2.53.7307     327,952  Msadce.dll    x86
				

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????. ?? ????? ??? ??????? ???? ??? ?? Microsoft MDAC 2.5 ?????? ????? ?????? Service Pack 3.

??????? ????

?? ???? ??????? ?? Microsoft OLE DB ?????? ?? Oracle (MSDAORA).

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

  1. ????? ???? Microsoft Visual Basic 6.0 ????? EXE Project. ?????????? ??? ????? Form1.
  2. ?? ??????? ??????? ???? "?????" ?? ?? ?????? ???? ??? 2.5 ?????? ?????? ActiveX Microsoft ?????.
  3. ?? ???? ???????? ???????? ??????? ?? ????? Form_Load Form1:
    
    
      Dim con As ADODB.Connection
      Dim rst As ADODB.Recordset
      
      Set con = New ADODB.Connection
      With con
        .CursorLocation = adUseClient
        .ConnectionString = "Provider=MSDASQL.1;UID=MyUser;PWD=MyPwd;DRIVER={Microsoft ODBC for Oracle};SERVER=MyServer;"
        .Open
      End With
      
      Set rst = New ADODB.Recordset
      With rst
        .ActiveConnection = con
        .CursorLocation = adUseClient
        .CursorType = adOpenStatic
        .LockType = adLockOptimistic
        'This one fails!
        .Source = "SELECT MyKey,UpdateVal,LookUpVal FROM UpdateTest WHERE (LookUpVal = 'Test2(Test2')"
        'This one works!
            '.Source = "SELECT MyKey,UpdateVal,LookUpVal FROM UpdateTest where LookUpVal='Test1'"
        .Open
      End With
      
      rst.Fields(1).Value = 200
      rst.Update
    					
  4. ????? ????? ??????? ??????? ????? ?? Oracle ??????.
  5. ????? ???? UpdateTest MyKey (??????? ???????) ? UpdateVal LookUpVal.
  6. ??? ???? ??? ???:
    • ????? ????? ????? ??? LookUpVal = Test2(Test2
    • ????? ??? ?????? LookUpVal = Test1

  7. ??? ???????.

???????

???? ???????: 292604 - ????? ??? ??????: 28/???? ??????/1435 - ??????: 3.2
????? ???
  • Microsoft Data Access Components 2.5 Service Pack 1
  • Microsoft Data Access Components 2.5 Service Pack 2
????? ??????: 
kbnosurvey kbarchive kbmt kbhotfixserver kbqfe kbmdac250sp3fix kbbug kbfix kboracle kbwin2000sp3fix KB292604 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????292604

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