connection polling

[Roz Lee]

I am having the same problem - running in a development environment,
single instance. Have checked that all my connections are being
closed. Performance counters, even tho they are not resetting
correctly, showing only low numbers of connections. It's driving me
crazy. Any other ideas please?

[ker beroz]

i am certain that ive already closed ALL my connections... but still im
getting this error...

hope u can help me with this one... tia

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Natty Gur]

Hi,

If you are running long executing queries change the Command
CommandTimeout property.

Natty Gur, CTO
Dao2Com Ltd.
28th Baruch Hirsch st. Bnei-Brak
Israel , 51114

Phone Numbers:
Office: +972-(0)3-5786668
Fax: +972-(0)3-5703475
Mobile: +972-(0)58-888377

Know the overall picture


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Kerberoz]

the query ran in 2 secs...


"Natty Gur" <natty@dao2com.com> wrote in message
news:umh%23%23KsRDHA.2248@TK2MSFTNGP12.phx.gbl...

> Hi,
> If you run the query in the SQL Query analyzer, what is the execution
> time ?
>
> Natty Gur, CTO
> Dao2Com Ltd.
> 28th Baruch Hirsch st. Bnei-Brak
> Israel , 51114
>
> Phone Numbers:
> Office: +972-(0)3-5786668
> Fax: +972-(0)3-5703475
> Mobile: +972-(0)58-888377
>
> Know the overall picture
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Natty Gur]

and if you remove the call to the DB , do you still get this error?

Natty Gur, CTO
Dao2Com Ltd.
28th Baruch Hirsch st. Bnei-Brak
Israel , 51114

Phone Numbers:
Office: +972-(0)3-5786668
Fax: +972-(0)3-5703475
Mobile: +972-(0)58-888377

Know the overall picture


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Kerberoz]

no its not,

i suspect that this is a ado.net thing kinna issue....

"Natty Gur" <natty@dao2com.com> wrote in message
news:uWMcGOtRDHA.2128@TK2MSFTNGP12.phx.gbl...

> Yep, I want to be sure that the access to the DB cause that error.
>
> Natty Gur, CTO
> Dao2Com Ltd.
> 28th Baruch Hirsch st. Bnei-Brak
> Israel , 51114
>
> Phone Numbers:
> Office: +972-(0)3-5786668
> Fax: +972-(0)3-5703475
> Mobile: +972-(0)58-888377
>
> Know the overall picture
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Salim Afþar]

When creating the Connection object add to the connection string this:
Max Pool Size=200,Enlist=true

if again get the same error try in connection string :
Pooling=false

I hope these help.

"Kerberoz" <dec698@hotmail.com> wrote in message
news:uxgFzUtRDHA.2676@TK2MSFTNGP10.phx.gbl...

> no its not,
>
> i suspect that this is a ado.net thing kinna issue....
>
> "Natty Gur" <natty@dao2com.com> wrote in message
> news:uWMcGOtRDHA.2128@TK2MSFTNGP12.phx.gbl...

> > Yep, I want to be sure that the access to the DB cause that error.
> >
> > Natty Gur, CTO
> > Dao2Com Ltd.
> > 28th Baruch Hirsch st. Bnei-Brak
> > Israel , 51114
> >
> > Phone Numbers:
> > Office: +972-(0)3-5786668
> > Fax: +972-(0)3-5703475
> > Mobile: +972-(0)58-888377
> >
> > Know the overall picture
> >
> >
> > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> > Don't just participate in USENET...get rewarded for it!

>
>

[fadi]

One thing, when you have connection pooling, first hit will open multiple
connections (the size of the pool) so that is normal as far as I am aware.
Running out of connections means some of the connections are remaining open
still.

Here are few things to try:
1. Turn connection pooling off and see how many connections being opened by
the application and are they being closed. To do so add "pooling=no" to the
connection string. (This may help the application last longer but does not
solve the connection problem and will happen again unless fixed)

2. When closing an SqlDataReader dispose of it rather than just closing it
using:
((IDisposable) reader).Dispose();

3. Run profiler and see which calls are not closing the connection. To do
so, do the following:

3.1 Open SQL Profiler and connect to the database. (Dialog will open)
3.2 Under Events Tab select the following:
Security Audit
Audit Login
Audit Logout
Stored Procedures
RPC:Completed
4. Run the trace and use your application.

I would personally hit each section of the application that i know calls the
database and look at profiler to see what happens. What you need to see is:

connection opened
procedure name
connection closed

Sometimes you may have nested calls, so connection closed may not show up
till later in the list. Make sure you have as many connections closed as
open. this will help you narrow down which connection not being closed and
figure out why.

Fadi
"Roz Lee" <rosl@panztel.com> wrote in message
news:b75327.0307091819.30cba805@posting.google.com ...

> I am having the same problem - running in a development environment,
> single instance. Have checked that all my connections are being
> closed. Performance counters, even tho they are not resetting
> correctly, showing only low numbers of connections. It's driving me
> crazy. Any other ideas please?

[fadi]

Turning pooling off does not fix the problem, it simply delay it. He has
open connections are are not getting closed.

"Salim Afþar" <safsar@luckyeye.com> wrote in message
news:uPFSLfvRDHA.2408@TK2MSFTNGP10.phx.gbl...

> When creating the Connection object add to the connection string this:
> Max Pool Size=200,Enlist=true
>
> if again get the same error try in connection string :
> Pooling=false
>
> I hope these help.
>
> "Kerberoz" <dec698@hotmail.com> wrote in message
> news:uxgFzUtRDHA.2676@TK2MSFTNGP10.phx.gbl...

> > no its not,
> >
> > i suspect that this is a ado.net thing kinna issue....
> >
> > "Natty Gur" <natty@dao2com.com> wrote in message
> > news:uWMcGOtRDHA.2128@TK2MSFTNGP12.phx.gbl...

> > > Yep, I want to be sure that the access to the DB cause that error.
> > >
> > > Natty Gur, CTO
> > > Dao2Com Ltd.
> > > 28th Baruch Hirsch st. Bnei-Brak
> > > Israel , 51114
> > >
> > > Phone Numbers:
> > > Office: +972-(0)3-5786668
> > > Fax: +972-(0)3-5703475
> > > Mobile: +972-(0)58-888377
> > >
> > > Know the overall picture
> > >
> > >
> > > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> > > Don't just participate in USENET...get rewarded for it!

> >
> >

>
>

[fadi]

Please read my reply to Roz. Also make sure you installed SP1 for MDAC 2.7

[url]http://www.microsoft.com/downloads/details.aspx?FamilyID=9ad000f2-cae7-493d-[/url]
b0f3-ae36c570ade8&DisplayLang=en

"ker beroz" <anonymous@devdex.com> wrote in message
news:#$PBXHpRDHA.1896@TK2MSFTNGP12.phx.gbl...

>
> i am certain that ive already closed ALL my connections... but still im
> getting this error...
>
> hope u can help me with this one... tia
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!