|
 |
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?
|
|
 |