Re: Persistent Connection

MTS .. ok.

Could you please tell me what I would do to keep the connection active ?

Also, how would my Activex Components use this connection. You see in the compoenent I am using ADO to make a conn to the DB. But every time a user hits the site then a new instance of the page loads up and it has to reconnect to the DB. So how do I tell my components to use the same connection to the DB ?

Thanks for your time !

Shiva

chensm wrote in message <7lc1me$ce13_at_eugwy1.bp.com>...
>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 Wed Jun 30 1999 - 20:53:16 CDT