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]