Thanks reggie, implement that and tested the scenario as per my first email, it work the desired way as per you have expected and suggested.
My feeling about the second scenario is that it is a bug. Try this link and search for the exception text: http://cvs.sourceforge.net/viewcvs.py/mysqlnet/mysqlclient/MySqlPoolManager. cs?rev=1.4 it has been great help! :-)TweeWan -----Original Message----- From: Reggie Burnett [mailto:[EMAIL PROTECTED] Sent: 08 April 2004 22:23 To: 'tweewan.wong'; [EMAIL PROTECTED] Subject: RE: Using BYTEFX to connect to MySql , closing connection do not release the connection. I'm not sure why this is happening, but the behavior you described in the first email is correct pooling behavior. By default, connection pooling is enabled which means connections are not killed when they are closed but remain open and able to serve new connections if necessary. Only when the app quits is the pool manager collected and the connections killed. If this is not desired, you can add pooling=false to your connection string. -reggie > -----Original Message----- > From: tweewan.wong [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 07, 2004 6:44 AM > To: [EMAIL PROTECTED] > Subject: RE: Using BYTEFX to connect to MySql , closing connection do not > release the connection. > > More information to add : > > Am using Bytefx 0.76 : > > I simplify the testing by using frmA call frmB. > In frmB, I do the following : > > Private Sub frmB_Load(ByVal sender As System.Object, ByVal e As > System.EventArgs) Handles MyBase.Load > Try > > > xx = New MySqlConnection > > xx.ConnectionString = "Data Source=127.0.01;" & _ > "Database=good;" & _ > "User ID=root;" & _ > "Password=;" > xx.Open() > xx.Close() > xx.ConnectionString = "" > xx.Dispose() > > MsgBox("Closed") > Catch ex As Exception > MsgBox(Err.Number & ex.Message) > End Try > End Sub > > In frmA, I have this tied to a button > Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As > System.EventArgs) Handles Button1.Click > Dim frm As frm_single > frm = New frm_single > frm.Show() > End Sub > > I press button1 in frmA, when frmB shows up, I close frmB, I press button1 > again in frmA and I get the following error: > > Pooling exception: Unable to find original pool for connection > > Regards > TweeWan > > > -----Original Message----- > From: tweewan.wong [mailto:[EMAIL PROTECTED] > Sent: 07 April 2004 15:02 > To: [EMAIL PROTECTED] > Subject: Using BYTEFX to connect to MySql , closing connection do not > release the connection. > > Hi, > > Encounter an interesting here using VB.NET with ByteFx.mysql.mysqlclient > to > connect to Mysql Database. > > I have a sub-form (called from another main form) with 4 mysqlconnections > declared and new. > X1= new mysqlconnection > X1.connectionstring = <a valid connection string> > X1.open() > > > X2= new mysqlconnection > X2.connectionstring = <a valid connection string> > X2.open() > > X3= new mysqlconnection > X3.connectionstring = <a valid connection string> > X3.open() > > X4= new mysqlconnection > X4.connectionstring = <a valid connection string> > X4.open() > > Msgbox("Phase 1") > > X1.close() > X2.close() > X3.close() > X4.close() > > Msgbox ("Phase 2") > > I am using MySQL Administrator to monitor the connection , at the Phase 1 > break point I can see that 4 connection is allocated. And at Phase 2 , I > expect the connection will be closed, but to my surprise, it did not. Not > until I quit entire application. Then I see the connections are release. > > Anyone has encounter this before and any pointers for me to investigate > further? > > > Regards > TweeWan > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
