Re: connections using this database: 105

From: Jeremy Davis (JeremyDavis_at_discussions.microsoft.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 06:48:02 -0800

What methods are you using to access your database?
If you're using ExecuteScalar, you ought to be ok, but if you're using
ExecuteReader you'll need to dispose your DataReader.

"Guoqi Zheng" wrote:

> I don't, because I am using microsoft application block data accesss, I
> supposed it will close it by itself????
>
> --
> Kind regards
>
> Guoqi Zheng
> guoqi AT meetholland dot com
> http://www.meetholland.com
>
> "Guadala Harry" <GMan@NoSpam.com> wrote in message
> news:Onu4YpuvEHA.720@TK2MSFTNGP10.phx.gbl...
> > Are you explicitly closing and disposing your connections? Like this...
> > cmd.Connection.Close();
> > cmd.Connection.Dispose();
> > cmd.Dispose();
> >
> >
> > -GH
> >
> >
> >
> > "Guoqi Zheng" <no@sorry.nl> wrote in message
> > news:uMuKu%23tvEHA.3620@TK2MSFTNGP09.phx.gbl...
> > > It is a little strange but I got 105 connections on the database of my
> new
> > > application.
> > >
> > > It sounds that each time, one user login, the connections always remains
> > > there for forever. I am always use microsoft application block for data
> > > access.
> > >
> > > Any idea where should I look for the problem???
> > >
> > > --
> > > Kind regards
> > >
> > > Guoqi Zheng
> > > guoqi AT meetholland dot com
> > > http://www.meetholland.com
> > >
> > >
> > >
> >
> >
>
>
>