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]
