ADOConnection - odd problem solved but why?

From: Peter Piper (NoEmail_at_Email.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 11:52:08 +0000 (UTC)

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: Error Connecting ADO from a Service Application
    ... "Kevin Frevert" wrote in message ... >> I can connect at design time an ADO connection from the form of a ... I set the connection to 'Use Windows NT Integrated Scurity' and did not work ... run time (but it worked design time). ...
    (borland.public.delphi.database.ado)
  • Re: module
    ... Dim adoConnection As ADODB.connection ... I don't understand why connection is not written Connection - that should be automatic. ... Copy that into google, including quotes. ...
    (microsoft.public.vb.general.discussion)
  • ADO Connection Failure
    ... Connection Failure error message. ... ADOConnection Status is still "Connected" erroneously. ... ADOConnection Level? ... without Closing all of the active Queries using that connection? ...
    (borland.public.delphi.database.ado)
  • Re: ADOConnection fail after a while in TThread
    ... I, as Martin, do not think it is wise to use so much of objects (both ADO and thread), Nevertheless you might increase the socket count etc. ... If you do not use Transactions and have only one Query per Connection you even do not need the Connection. ... The simpliest the best:) Solve the problem with "not permanent" connection to your stores. ... One strange thing is that I have a ADOConnection in the main thread as well. ...
    (borland.public.delphi.database.ado)
  • ADOConnection.Connected does not show lost connection.
    ... I am using ADOConnection object in order to connect to an MS SQL Server 2000 ... I am using the ADOConnection.Connected property to see if the connection is ... still active, but once connected, event if I loose internet connection, it ...
    (borland.public.delphi.database.ado)