It matters greatly what software/drivers you are using to connect with. You need to first consult the documentation for CoreLab's MySQLDirect for details about whether it pools connections or not. The connections are pooled client-side, not server-side so I would start with that library.
You may also want to glance through the .NET docs too. I don't know if MySQLDirect has it's own objects or if you just use it as you would an ODBC driver through the ADO framework. That could mean that you are getting an additional layer of "assistance" from the .NET/ODBC manager libraries. That "assistance" may also be pooling connections for you (in an attempt to help). Personally, I have had to sometimes dig very deep to find adequate documentation about some of Microsoft's "assistance" features in order to figure out how to either turn them on, turn them off, or learn how to live with their unruly behaviors. Good luck, sorry I wasn't more help... Shawn Green Database Administrator Unimin Corporation - Spruce Pine Jeff Demel <[EMAIL PROTECTED]> wrote on 09/14/2004 10:30:20 AM: > I recently had an issue where I was getting "timeout waiting for > connection" and "max pool size" type errors. I finally was able to > resolve the problem by setting pooling=false in the connection string. > > While I'm happy to have resolved the error, it made me realize that I > have no idea what is going on with connections and pooling on mySQL, so > I thought I'd ask the group here for some basic instruction on this > issue, and maybe a good link or two to some site or page or page that > explains it in detail. The manual either doesn't go into any detail or > I am not searching with the appropriate keyword(s). I just need a > little direction and some detailed information on how connections and > pooling works. > > I'm using ASP.NET/VB.NET with CoreLab's MySQLDirect on a Windows 2003 > IIS server with the latest windows version of MySQL, if that matters. > > TIA > > -Jeff > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
