FIX: ??????? ?????? ??????? ?? ADO ???? ?????

?????? ????????? ?????? ?????????
???? ???????: 247757 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ??????? Windows Foundation ???? ?? Java (WFC) ADO ?? ??? ???? ?????? ????? ???????? ??? ??? ?????? ????????? ???? ???? ????? ??????? ?? ??? ????? ????????? ???? ??? ????, ??? ???? ??? leaked ?????????. ??????? ?????? ??? ??? ??????? ??????? System.gc() ??? ????? ??????? ADO ?? ???? COM Java. ?? ??????? ??????? ?? ????? ??? ??????? System.gc() ??? ????? ????? ADO ?????? ???????.

????

?? ????? ??? ??????? ?? ???? ??? ?????? ?? Windows 2000 ? MDAC 2.5.
  • ??? ??? ???????? ??? ?????? ??? ???? ???? ???? ????? ??????? Windows 2000. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    260910????? ?????? ??? ???? ???? ???? ??????? Windows 2000
  • ??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? Microsoft ?????? Access ?????? 2.5. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    293312INFO: ????? ?????? ??? ???? MDAC 2.5 ???? ???????
??? ?? ???? ?????? ?????????? ?? ??? ??????? ???? ??????? ??????? ?? ????:
File name       Date        Size      Version      
-----------------------------------------------------
Msado15.dll     1/26/2000   329KB     2.12.4926.0
				

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft Access SP2 Objects2.1 ? 2.5. ?? ????? ??? ??????? ???? ??? ?? Microsoft ?????? Access ?????? 2.5 ?????? ????? ?????? Service Pack 2 "?" Microsoft Windows 2000 Service Pack 2.

??????? ????

???????/???? ??? ???? ??????? ???? ??? ???? ???? ?????? ???????:
  1. ??? ????? Microsoft ?????? Access ?????? 2.1 SP2.
  2. ??? ??????? ???? ADO ??????? ??? ??????.
  3. ??? ??????? ???? COM Java ?? MTS ?? COM +.
  4. ????? ???? COM Java ?????? ????? ?? ??? ???????.

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

  1. ????? ????? ???? COM Java ?????? ConnLoss ?? Visual J ++ 6.0 ???????? ????????? ???????? ???????:
    import com.ms.wfc.data.*;
    
    public class ConnLoss
    {
      // Modify this connection string to point to a running SQL Server.
      private static String m_connect = 
        "Provider=SQLOLEDB;Server=(Local);Database=Pubs;UID=sa;PWD=;";
      public com.ms.wfc.data.adodb._Recordset 
        FindAuthorsLastName( String au_id, boolean fCallGC )
      {
        Connection conn = null;
        Command cmd   = null;
        Recordset rs  = null;
        try
        {     
          // Open connection to SQL Server.
          conn = new Connection();
          conn.setCursorLocation( AdoEnums.CursorLocation.CLIENT );
          conn.open( m_connect );
          
          // Prepare command object.
          cmd = new Command();
          cmd.setActiveConnection( conn );
          
          cmd.setCommandText( "select au_lname from authors where au_id=?" );
        
          cmd.getParameters().append( 
            cmd.createParameter( "au_id", 
                       AdoEnums.DataType.VARCHAR,
                       AdoEnums.ParameterDirection.INPUT,
                       20, au_id ) );
          
          // Execute command.
          rs = cmd.execute();
          
          // Disconnect recordset and close connection.
          rs.setActiveConnection( (Connection) null );
          conn.close();
          
          // Call gc if requested.
          if (fCallGC) System.gc();
          
          // Return disconnected recordset.
          return (com.ms.wfc.data.adodb._Recordset) rs.getDataSource();
          
        }
        catch( AdoException adoEX )
        {
          // Log errors here.
        }
        return null;
      }
    }
    					
  2. ????? ???? COM Java MTS ?? ???? COM +.
  3. ??????? ???? COM Java ?? ?????? Microsoft Visual Basic ????????? ???????? Applications (VBA):
    Sub TestConnLoss()
    Dim objCL As Object
    Dim i As Long
    Dim rs As ADODB.recordset
      set objCL = CreateObject("ConnLoss.ConnLoss")
      For i = 1 To 100
        Set rs = objCL.FindAuthorsLastName("756-30-7391", False)
        Debug.Print rs.Fields("au_lname").Value
        rs.Close
        Set rs = Nothing    
      Next i    
    End Sub
    					
  4. ????? ????? ???? Windows NT ??? ?????? ??? ???? SQL Server 7.0 ??????? "??????? ??????????" ??? ???? ?????? SQL Server: ??? ??????????.
  5. ????? ????????? ???????? ?????? VBA. ??? ??? ??????? ??? ????? ??????? ?????????? 100 ?????? ????? ??? ?? ??????? ???? ?? ??? ????? ???? Windows NT ???? ??? ?? ???? ???? OLE DB ?? ???? ???? ???? ????? SQL OLE DB ????????? ?? ??? ???? COM Java.

  6. ????? ??????? ??????? FindAuthorsLastName ??? True ?????? ??? System.gc().
  7. ????? ?????? ????? ???? MTS ?? COM +.
  8. ????? ????????? ???????? ?????? VBA ??? ?????.
??? ??? ?????? ??? ????? ??? ??????? ?????????? ??? ?????? ??? ???? ??? ?? ???? ???? OLE DB ???? ???? ???? ????? SQL OLE DB ????????? ?? ??? ???? COM Java ????? ??? ??????? System.gc().

??????: ????? System.gc() ???? ???? ???? COM Java ???? ????, ??? ??????? System.gc() ??? ??? ???? ????? ?? ??? ?????? ?? ????????. ??? ???? ??????? ?? ???? ????? ???? ??????? ??????? System.gc() ???????? ????? ?? 10 ?? 100 ?????? ??? ?? ????? ????? ?????? ?? ??????? System.gc(). ?????? ?? ??? ???? ??????? ?????? ????? ??? ?????? ?????? ????? ?????? ??? ??????? ??? ????? SQL ??? ??? ??????? ?????? ??????? ??????? ??? ?? ?????? ?????; ??? circumvents ??????? ?????.

???????

???? ???????: 247757 - ????? ??? ??????: 21/???? ??????/1435 - ??????: 3.0
????? ???
  • Microsoft Data Access Components 2.1 Service Pack 2
  • Microsoft Data Access Components 2.5
  • Microsoft Visual J++ 6.0 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbqfe kbhotfixserver kbbug kbfix kbmdac250sp2fix KB247757 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????247757

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