[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: ODBC and MS Access 97
From:       "Hendrik M.J. Arnoldus" <hendrik () arnoldus ! com>
Date:       1999-10-20 15:07:47
[Download RAW message or body]

    Defragging the hard disk is a good thing to do anyhow, particularly as
NT does not come equipped with a defragger (Win2000 will have a utility).

Regarding the solution, connection pooling has the advantage that available
connections are re-used, which is useful, as it saves server resources.
However, the fact that connection pooling solves this particular problem
seems to point to a design flaw: Too many connections are opened during the
process (and they are probably not closed either). Using ASP, you should
close and destroy each object (objects, recordsets, connections) when not
needed anymore:

If IsObject(MyObject) Then
    If MyObject.State = 1 Then    ' Object is open
        MyObject.close
    End If
    Set MyObject = NOTHING
End If

Hendrik M.J. Arnoldus

You cannot rely on IIS to destroy the objects
----- Original Message -----
From: <ballier@ods.schule.de>
To: Hendrik M.J. Arnoldus <hendrik@arnoldus.com>
Cc: <monty@tcx.se>; <myodbc@lists.mysql.com>
Sent: Wednesday, October 20, 1999 2:32 PM
Subject: Re: ODBC and MS Access 97


> Hello,
>
> On Wed, 20 Oct 1999, Hendrik M.J. Arnoldus wrote:
>
> > In addition to the advice given by Monty, I would also defrag the hard
disk
> > if I were you.
>
> Thanks for your answers, but this could not been the reason, because the
> hard disk noises ONLY during ODBC connection.
>
> Meanwhile I have found the right place for correct this problem.
> In NT there is a bottom "ODBC driver" for installation and configuration.
> There ist a card "Connection pooling" (in German: Verbindungs-Pooling").
> If I mark the radio bottom "supervision of power activated" (in German:
> Leistungsueberwachung aktiviert). Now the hard disk is quiet a the
> connection is quick.
>
> Ralph
>
> >
> > Hendrik M.J. Arnoldus
> >
> > ----- Original Message -----
> > From: Michael Widenius <monty@monty.pp.sci.fi>
> > To: <ballier@ods.schule.de>
> > Cc: <myodbc@lists.mysql.com>
> > Sent: Wednesday, October 20, 1999 5:13 AM
> > Subject: ODBC and MS Access 97
> >
> >
> > > >>>>> "ballier" == ballier  <ballier@ods.schule.de> writes:
> > >
> > > ballier> Hello,
> > > ballier> I have installed myodbc 2.50.24 with myodbc.dll 2.50.25 under
> > NT4.0 SP5.
> > >
> > > ballier> I use MS Access 97 as client program.
> > >
> > > ballier> I can make a ODBC connection to a mysql database on Linux
over
> > ISDN
> > > ballier> and tie up the tables.
> > > ballier> But it is very slowly. There is a loud noise of my hard disk
> > without any
> > > ballier> pause. (I think, hard disk will be broken after some hours of
> > this quick
> > > ballier> head motions :-))).
> > >
> > > ballier> The loud noise of hard disk is independent of transmission of
> > data. You see
> > > ballier> the data form, hear the noise, wait, hear the noise,..., then
> > press
> > > ballier> the button "next data", wait, wait, wait, hear the noise....
then
> > appears
> > > ballier> the next data record.
> > >
> > > ballier> Can you help me? Do you know what's the reason for this?
> > >
> > > Hi!
> > >
> > > Try disabling ODBC logging and MyODBC tracing and try again.
> > >
> > > If this doesn't help, then it's time to replace your hard disk :)
> > >
> > > Regards,
> > > Monty
> > >
> > > ---------------------------------------------------------------------
> > > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
before
> > > posting. To request this thread, e-mail
myodbc-thread800@lists.mysql.com
> > >
> > > To unsubscribe, send a message to the address shown in the
> > > List-Unsubscribe header of this message. If you cannot see it,
> > > e-mail myodbc-unsubscribe@lists.mysql.com instead.
> > >
> > >
> >
> >
>
>         Verein zur Foerderung eines Offenen Deutschen Schul-Netzes e.V.
>             Ralph Ballier, Vorstand ODS-Verein e.V., 12357 Berlin
>  E-Mail: ballier@ods.schule.de, Tel.: 030 - 66 09 81 16, Fax: 030 - 66 09
81 25
>                             http://www.schule.de
>
>


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread804@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]