Re: ADOConnection - odd problem solved but why?

From: Moi (jcema_at_rocketmail.com)
Date: 12/27/04 

Date: Mon, 27 Dec 2004 16:07:18 -0500

Peter,
Do you close your connection in your code before terminating the app ?
If so, where ? Could it be that you release the form before closing the
connection ?

Marcel

"Peter Piper" <NoEmail@Email.com> a écrit dans le message de
news:cpmk58$q03$1@hercules.btinternet.com...
> I have a form with an ADOconnection and two tables.
> The form is created on the fly (ie. not auto created).
> When i close my application i get an Access Violation Exception unless
> the ADOconnection Connected property is set to true at *design time*.
> Set to True at design time, no exception.
>
> I have used ADO in nearly every big app I have ever wrote and never had
> this before.
>
> Now all I can think is because the are more than one instances of the
> form something odd is happening. Why settings connected to true should
> solve this i dont know.
>
> Maybe an application cannot handle more than one ADO connection at once
> to the same database - ???
>
> Any one any ideas?
>
> Cheers Pete.
>
>

Relevant Pages

  • Re: A month with a Nokia n95 (long)
    ... and can't play. ... One of these days I will get around to writing a small app to do it all on the fly. ... HSDPA works well and you can have more than one internet connection going at once. ... For example I can use it as a modem for my laptop and also "listen again" to a Beeb radio programme. ...
    (uk.telecom.mobile)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... Have the App create a single ADODB.Connection object, ... requesting only one connection from a single ADO Connection ... Pool, thus if all requests are sequenced and not over-lapping ...
    (microsoft.public.vb.database.ado)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... your first paragraph where it talks about "a VB6 app". ... requesting only one connection from a single ADO Connection ... ' at this point a new SQL process HAS been created!! ...
    (microsoft.public.vb.database.ado)
  • Memory leak with ADO
    ... When the app runs through the loop 2k times about 16-30 megs ... procedure TForm1.SpeedButton1Click(Sender: TObject); ... Caption = 'Connection String' ... object Connection: TADOConnection ...
    (borland.public.delphi.database.ado)
  • Re: What is the perfect application model?
    ... If your app is only being used on an intranet or on a high speed internet connection fine. ... For the fiber connections it would be fine, but for the DSL users their productivity would drop considerably by forcing them to run all their apps through the network. ...
    (microsoft.public.dotnet.general)