[program-l] Re: VB6: Connection Object

  • From: "Corbett, James" <James.Corbett@xxxxxxxxxxxxxxx>
  • To: "'program-l@xxxxxxxxxxxxx'" <program-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Sep 2005 14:58:04 -0400

Mark:

Sounds like you know a lot about yanking the wire!

Jim 

-----Original Message-----
From: Mark Long [mailto:Mark.Long@xxxxxxxxxxxxx]
Sent: September 6, 2005 12:02 PM
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] Re: VB6: Connection Object


No idea but I know how to find out. Yank the network cable while repeatedly
checking the state and then you will be able to say for sure.

-----Original Message-----
From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Corbett, James
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: