Looks like it could be a bug. I'll check it out. > -----Original Message----- > From: tweewan.wong [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 07, 2004 8:13 PM > To: [EMAIL PROTECTED] > Subject: RE: Using BYTEFX to connect to MySql , closing connection do not > release the connection. > > 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/MySqlPoolManage > r. > 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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
