Are you using connection pooling?
> -----Original Message-----
> From: Bryan Luisana [mailto:bluisana@stripped]
> Sent: Wednesday, February 02, 2005 12:47 PM
> To: dotnet@stripped
> Subject: Dataadapter doesn't disconnect?
> Is anyone else having an issue when using the a mysqldatadapter.
> Even doing something as simple as the code below creates a conneciton that
> sleeps after I
> am done with it. This means that everytime a new user connects to my
> webpage a new
> conneciton is made untill the mysql max connections is reached.
> MySqlConnection connection = new MySqlConnection(constr);
> MySqlCommand myCommand = new MySqlCommand(sqlCommand);
> myCommand.CommandType = CommandType.Text;
> MySqlDataAdapter dataAdapter = new MySqlDataAdapter(myCommand);
> DataTable myDataTable = new DataTable();
> Neither the close nor the dispose method makes the connection to the
> database close?
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe: http://lists.mysql.com/dotnet?unsub=1