Keeping connections open

[aidanh]

I am very new to asp, and I am wondering what is the best way to get around a this problem

I use asp to give me a status on a database which is changing frequently. I open a connection to the database at the begining of the the script, and then execute a command to obtain a recordset

If I want the information in the asp page to be constantly up to date, the only way I can see to do this is to refresh the page at intervals, which opens the database again, and executes command again

Is there a neater way to do this? Or is this the only way

aidanh

[CJM]

It's generally considered good practice to get in & get out as quickly as
possible. This means you should open your connection at the last moment, do
your stuff, then rest the connection as quickly as possible.

Given this, your solution is the right way (providing you ARE closing the
connect afterwards(?)).

If you use the same connection string each time, it will keep using the same
pooled connection, which is another good practice to adopt.

So in answer to your question... this IS the neat way...

Chris

"aidanh" <anonymous@discussions.microsoft.com> wrote in message
news:904C39DB-D8E0-47B9-B314-4963116BB55A@microsoft.com...

> I am very new to asp, and I am wondering what is the best way to get

around a this problem:

>
> I use asp to give me a status on a database which is changing frequently.

I open a connection to the database at the begining of the the script, and
then execute a command to obtain a recordset.

>
> If I want the information in the asp page to be constantly up to date, the

only way I can see to do this is to refresh the page at intervals, which
opens the database again, and executes command again.

>
> Is there a neater way to do this? Or is this the only way?
>
> aidanh

[Bob Barrows [MVP]]

aidanh wrote:

> I am very new to asp, and I am wondering what is the best way to get
> around a this problem:
>
> I use asp to give me a status on a database which is changing
> frequently. I open a connection to the database at the begining of
> the the script, and then execute a command to obtain a recordset.
>
> If I want the information in the asp page to be constantly up to
> date, the only way I can see to do this is to refresh the page at
> intervals, which opens the database again, and executes command
> again.
>
> Is there a neater way to do this? Or is this the only way?
>
> aidanh

If you have no client-side code restirctions, then you can use XMLHTTP to do
this without refreshing the page. Please follow-up in a client-side coding
newsgroup (one of the scripting groups, or one of the groups with "dhtml" in
their names) if you wish to pursue this option.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.