Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Connected?


Message #1 by "Ruud Voigt" <RuudVoigt@w...> on Wed, 10 May 2000 09:25:26 +0200
Is there a way to test if a connection

(server.createobject("adodb.connection")) is still

active, like a isConnected property or something like that?

Message #2 by "Shawn Steward" <ssteward@a...> on Wed, 10 May 2000 14:58:33
You can use myConnection.state.  This will return 0 if the connection is 

closed, 1 if it's open.



Shawn





On 05/10/00, "Ruud Voigt" wrote:

> Is there a way to test if a connection

(server.createobject("adodb.connection")) is still

active, like a isConnected property or something like that?

Message #3 by "Ruud Voigt" <RuudVoigt@w...> on Wed, 10 May 2000 16:28:27 +0200
Thank you,

I've been trying to figure this out for some time,

there just had to be a method or property to do this,

it's such an obvious function, I just couldn't seem to

find it.



Regards

RUUD



-----Original Message-----

From: Shawn Steward 

Sent: woensdag 10 mei 2000 14:59

To: ASP Databases

Subject: [asp_databases] Re: Connected?





You can use myConnection.state.  This will return 0 if the connection is

closed, 1 if it's open.



Shawn





On 05/10/00, "Ruud Voigt" wrote:

> Is there a way to test if a connection

(server.createobject("adodb.connection")) is still

active, like a isConnected property or something like that?

Message #4 by "Matthew Lohr" <mlohr@t...> on Thu, 11 May 2000 15:31:01 -0400
I am having problems with a script.  It works in one database.  When I

change the table for it to add data to it makes an entry into the table but

it is blank.  All my data fields are spelled correctly.  The fields just

come up empty



 -----Original Message-----

From: 	Ruud Voigt []

Sent:	Wednesday, May 10, 2000 3:25 AM

To:	ASP Databases

Subject:	[asp_databases] Connected?



Is there a way to test if a connection

(server.createobject("adodb.connection")) is still

active, like a isConnected property or something like that?

Message #5 by Kevin D Riggs <kevin.riggs@p...> on Fri, 12 May 2000 04:45:47 -0400
Matthew,



	Can you send some of the script?





KD



Kevin D. Riggs



kevin.riggs@p...



Programmer/Analyst III

UnumProvident Insurance

Chattanooga, TN 37402

(xxx) xxx-xxxx



ICQ - 2185058

AIM - wsi tn



http://www.mindspring.com/~riggsck/

Message #6 by "Shawn Steward" <ssteward@a...> on Fri, 12 May 2000 22:42:35
No problem, glad to help!



shawn



On 05/10/00, "Ruud Voigt" wrote:

> Thank you,

I've been trying to figure this out for some time,

there just had to be a method or property to do this,

it's such an obvious function, I just couldn't seem to

find it.



Regards

RUUD



-----Original Message-----

From: Shawn Steward 

Sent: woensdag 10 mei 2000 14:59

To: ASP Databases

Subject: [asp_databases] Re: Connected?





You can use myConnection.state.  This will return 0 if the connection is

closed, 1 if it's open.



Shawn





On 05/10/00, "Ruud Voigt" wrote:

> Is there a way to test if a connection

(server.createobject("adodb.connection")) is still

active, like a isConnected property or something like that?


  Return to Index