Re: Persistent Connection

There are several ways to this problem. If you have a MTS in your server, you can use MTS to maintain a connection pool for you.
If you do not have, I think you can use ADO to create a connection for all instance and use this connection to open different database. For exmple: In application_start or session_start, create a global connection. and then set the activx component's connection to this global connection.

BTW: is this a proble belong to oracle server?

Shiva Nadarajah wrote in message <7lbsqs$qci$1_at_info2.uah.edu>...
>
>I am using Activex components on my web site to communicate to a DB.
>However, each instance of the compoenent has to make its own connection to
>the DB and this becomes slow when the traffic on the web site is high.
>
>Is there anyway I can keep an open connection to a DB so that all my
>components can use it to talk to the DB as opposed to every component
making
>its own connection.
>
>Thanks for your help!
>
>Best regards,
>Shiva
>
>
Received on Tue Jun 29 1999 - 22:14:03 CDT