Keeping Connection Open - Consequences?

[Mike]

I have an application where I need to keep the connection
open because my application monitors 2 separate databases
ever 1 second. Is there a consequence of keeping it open
and using recordsets from that connection?

Reason why, if I open it and close it after each use, I
run into lots of errors because of it being open then it
generates error messages. THe application does a lot of
FTP processes and updates to either or both databases.

Thanks for any and all help.

Mike

[Mike D]

How do you keep a connection open. You can't keep one open from an asp
page.


Mike D

"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:024d01c3c0d4$8e9f2520$a101280a@phx.gbl...

> I have an application where I need to keep the connection
> open because my application monitors 2 separate databases
> ever 1 second. Is there a consequence of keeping it open
> and using recordsets from that connection?
>
> Reason why, if I open it and close it after each use, I
> run into lots of errors because of it being open then it
> generates error messages. THe application does a lot of
> FTP processes and updates to either or both databases.
>
> Thanks for any and all help.
>
> Mike

[Mark Schupp]

What error messages do you get when you open and close it on each use?
What DBMS is it?

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:024d01c3c0d4$8e9f2520$a101280a@phx.gbl...

> I have an application where I need to keep the connection
> open because my application monitors 2 separate databases
> ever 1 second. Is there a consequence of keeping it open
> and using recordsets from that connection?
>
> Reason why, if I open it and close it after each use, I
> run into lots of errors because of it being open then it
> generates error messages. THe application does a lot of
> FTP processes and updates to either or both databases.
>
> Thanks for any and all help.
>
> Mike