[program-l] Re: VB6: Connection Object
- From: "Corbett, James" <James.Corbett@xxxxxxxxxxxxxxx>
- To: "'program-l@xxxxxxxxxxxxx'" <program-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Sep 2005 12:38:58 -0400
David:
I think you are refering to the Recordset object in your example. I have
just read the help on the State property but the example with in is centered
on the Recordset. I am looking for the state of the AODB object its self.
The recordset object is a child of this parent.
Jim
-----Original Message-----
From: David Lant [mailto:david.lant@xxxxxxxxxxxx]
Sent: September 6, 2005 12:08 PM
To: 'program-l@xxxxxxxxxxxxx'
Subject: [program-l] Re: VB6: Connection Object
Hi Jim,
One would have thought that it checks the actual connection to the database,
as you can use it not only to find out if the connection is open or closed,
but what it is actually doing at the time. E.g. you can compare the State
property against the adStateOpen, adStateClosed, adStateExecuting,
adStateFetching and adStateConnecting constants.
David Lant
I.T. Consultant
Consultancy & Development
ICT Services
Tel: (01392) 382464
Devon County Council accepts no legal responsibility for the contents of
this message. The views expressed do not reflect those of Devon County
Council.
-----Original Message-----
From: Corbett, James [mailto:James.Corbett@xxxxxxxxxxxxxxx]
Sent: 06 September 2005 16:56
To: Program-L (E-mail)
Subject: [program-l] VB6: Connection Object
Hello all:
I have the need to frequently check my ADO Connection object for viability.
If I use the Object.State property does that actually check the connection
to the database or simply the existance of the object in memory?
Jim
James M. Corbett
(613) 941-8303 | facsimile / télécopieur 613 941-8720 | TTY/ATS
1-800-665-0354 James.Corbett@xxxxxxxxxxxxxxx IT Programmer/Analyst | GST/HST
Division | Information Technology Branch Programmeur/Analyste en technologie
de l'information | Division de la TPS/TVH | Direction générale de
l'informatique Canada Revenue Agency | 875 Heron Rd., Ottawa, ON K1A 0L5
Agence du revenu du Canada | 875 Ch. Heron, Ottawa ON K1A 0L5 Government of
Canada | Gouvernement du Canada
"The following Ha Ha is not for amusement, but an expression of contempt...
Ha Ha!"
Nelson Mudge
Now this is not the end. It is not even the beginning of the end. but it is,
perhaps, the end of the beginning."
Winston Churchill
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
