Re: Newsgroup: Serious memory leakage while using ADO recordset

"Victor Koch" <victor_at_correo.waldbott.com.ar> wrote
> Hi Ed, try this
>
> Dim cn As String
> Dim query As String
> Dim connection As New ADODB.connection
> Dim rs As ADODB.Recordset
> Set rs = New ADODB.Recordset
>
> cn = "Provider=OraOLEDB.Oracle.1;Data Source=mydatasource;User
> Id=User;Password=password;FetchSize=100;CacheType=Memory;PLSQLRSet=1"
> query = "Select * FROM LeakTab where FirstCol = 'Dummydata0001'"
> connection.Open cn
> For i = 1 To 10000
> rs.ActiveConnection = connection
> rs.CursorLocation = adUseClient
> rs.CursorType = adOpenStatic
> rs.LockType = adLockBatchOptimistic
> rs.Open query , , , , adCmdText
> rs.Close
> Next
> connection.Close
>
> --
> Víctor Koch From Argentina.

Victor,

Thanks - but I'm afraid it leaks with both the 9.2.0.1 and 9.2.0.2 OLEDB drivers.

Ed. Received on Thu Jun 19 2003 - 12:20:30 CEST