Connection Pooling(Expecting Quick reply to get help)

Hi Guys,
I had through with all of you guys discussion , Subjected by "ODBC / OLE DB
Connection Pool". Found quite intresting & helpfull.

Comeing to my problem by using (OLEDB , DB = Sybase)--


PREVIOUS IMPLEMETATION
We Have some services running for 24 X 7.
In those services we were opening one connection for each service , and
open/close session for each transaction.
we were opening the connection by call of
OpenWithServiceComponents(......)
But we were facing the DBSlowness for most of our Storeproc's.it could be
any StoreProc which shows delay. And all of the Store procs are very simple
without any bussiness implementaion.


CURRENT IMPLEMETATION
Then we had decided to open some number of connection's through our service
only , and disable the Connection pooling by DB.
So we had executed
for(.....< SOME_NUMBER....)
OpenWithServiceComponents(......)

and to disable the connection pooling we had set some of the propertoes as
follow.
DBPROP_INIT_OLEDBSERVICES = ~DBPROPVAL_OS_RESOURCEPOOLING
Also tried to
DBPROP_INIT_OLEDBSERVICES = -4.
Also changed the registry settings as per recccomended by
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/pooling2.asp),
Now the issue is ,
Still we are having our connection getting grow more than our numbers ,
means we have got fail to disable connection pooling.
And still facing the DB Slowness issue also.

It is an Critical issue for us now , so any quick help would be appriciated.
Thanx in advance.
regards ,
Pardeep Kadian






.

Relevant Pages

  • Re: ado connection object in vb6
    ... "Global connection objects are bad in so many ways. ... The key is that ADO uses 'connection pooling'. ... "Pooling in the Microsoft Data Access Components" ...
    (microsoft.public.vb.database.ado)
  • Re: MDAC question
    ... The MDAC downloads are labeled by the ... I suggested that the ADO data library is ... He simply created a connection object and set its connection time ... Connection pooling is just the kind of 'hidden' ...
    (microsoft.public.vb.general.discussion)
  • Re: MDAC question
    ... The MDAC downloads are labeled by the ... I suggested that the ADO data library is ... He simply created a connection object and set its connection time ... Connection pooling is just the kind of 'hidden' ...
    (microsoft.public.data.ado)
  • Re: MDAC question
    ... The MDAC downloads are labeled by the ... I suggested that the ADO data library is ... He simply created a connection object and set its connection time ... Connection pooling is just the kind of 'hidden' ...
    (microsoft.public.vb.database)
  • Re: Connection issues
    ... Connection pooling will have no impact on performance in a Windows Forms ... Test for errors on the server by checking @@Error. ... > one SP inserts a row with an identity column. ...
    (microsoft.public.dotnet.framework.adonet)