Re: Reading Access DB: get someteimes Data - sometimes not

From: Val Mazur (group51a_at_hotmail.com)
Date: 07/29/04 

Date: Wed, 28 Jul 2004 21:34:43 -0400

Hi Marcel,

Try to run Component Checker, which ships with MDAC to see if MDAC
installation is OK. Did you check if you are not experiencing any memory
leaks in your application? Try one more solution - close your connection to
the database periodically. It should release some memory, which Jet holds
when you open multiple recordsets. 

-- 
Val Mazur
Microsoft MVP
"Marcel Gätzi" <MarcelGtzi@discussions.microsoft.com> wrote in message 
news:35748F48-8887-4D65-8AC0-40AB35695980@microsoft.com...
> Hi Val,
>
> I'm glad you don't see anything wrong in my Code. I use the "if rst.BOF 
> ..." line for debuging reasons. You mentioned "MDAC corruption". Can this 
> explain the situation?
>
> I don't get no data on this specific server - it works fine until a 
> certain time, after this I only get EOF and after another while the server 
> crashes. Who can I fix MDAC corruption?
>
> Thank you very much for your help!
>
> Marcel
>
> "Val Mazur" wrote:
>
>> Hi,
>>
>> I do not see anything wrong in a code, except it could be simpler. If it
>> works on all PCs, except one, then it could be related to the MDAC
>> corruption. Do you get any error message?
>> Your code actually should look like (you do not need to check for BOF and
>> EOF in your case and do not need to use MoveNext)
>>
>>  Set rst = cmd.Execute()
>>
>>    If Not rst is Nothing Then
>>       Do While Not rst.EOF
>>          '*************************   in the beginning, data is retrieved
>>          Call rst.MoveNext
>>       Loop
>>    End If
>>
>> -- 
>> Val Mazur
>> Microsoft MVP
>

Relevant Pages

  • Re: VB6 Questions
    ... "Krishna Prabhu" wrote in message ... > I also have confirmed that MDAC is installed successfuly. ... > "Val Mazur" wrote: ... You could download it ...
    (microsoft.public.vb.database.ado)
  • Re: Application Error 1000
    ... MDAC to see if it is fine or not. ... > "Val Mazur" wrote: ... >> that since you application uses DSN, ADO will use OLEDB for ODBC between ... >>> is written to the log file. ...
    (microsoft.public.vb.database.ado)
  • Re: W2K to XP ADOX 2.5/2.8 problem
    ... Did not you install any third-party components, ... upgrade MDAC? ... "Juan Ciervo" wrote in message ... >>> Val Mazur ...
    (microsoft.public.vb.database.ado)
  • Re: Installing MDAC 2.7 and JET 4.0
    ... MSDN. ... >>> a Component Checker to see if MDAC is OK or not. ... >>> Val Mazur ... >>> Microsoft MVP ...
    (microsoft.public.vb.database.ado)
  • Re: Recordset gets corrupted
    ... "prash" wrote in message ... > is there any paramter that i have to set to get the record set unicode ... > "Val Mazur" wrote in message ... I think you need to install localizable copy of MDAC to work ...
    (microsoft.public.vb.database.ado)