RE: Connection Pooling

[Darren Hill]

Thanks,

I've uploaded the changes necessary to use AppBlocks 3.0 with
MySql.Data.  Enjoy!

Note.  When using GetParameter, ensure you specific the DbType  [ie.
GetParameter("?username", username, DbType.String) ] you are using.  I
never had to do this for the ByteFX version, but for some reason, if you
leave out the specification, it defaults to Int32.

Darren Hill
darren@stripped
Tel: [phone] ext. 2
Toll Free: 866-410-1154 ext. 2
Fax: [phone]


-----Original Message-----
From: Reggie Burnett [mailto:reggie@stripped] 
Sent: October 28, 2004 3:32 PM
To: darren@stripped; 'Guy Platt'
Cc: dotnet@stripped
Subject: RE: Connection Pooling

Good work Darren

> -----Original Message-----
> From: Darren Hill [mailto:darren@stripped]
> Sent: Thursday, October 28, 2004 9:26 AM
> To: 'Guy Platt'
> Cc: dotnet@stripped
> Subject: RE: Connection Pooling
> 
> Guy,
> 
> There's a workspace at godotnet.com.  Its tremendous, and I've
extended
> it to use Reggie's connector.  Let me know if you interested and I'll
> send you the source.  I'm going to contribute it to the workspace
soon.
> 
> Darren Hill
> darren@stripped
> Tel: [phone] ext. 2
> Toll Free: 866-410-1154 ext. 2
> Fax: [phone]
> 
> 
> -----Original Message-----
> From: Guy Platt [mailto:guy.platt@stripped]
> Sent: October 28, 2004 2:37 AM
> To: darren@stripped
> Cc: dotnet@stripped
> Subject: Re: Connection Pooling
> 
> This sounds interesting using the ApplicationBlocks with MySql.  Did
you
> 
> convert the MSSQL ApplicationBlocks to use with MySQL, and if so, is
it
> something you can share with the list?
> 
> regards
>   Guy
> 
> 
> Darren Hill said the following wise words on 2004-10-28 1:25 AM:
> 
> >Reggie,
> >
> >I'm using ApplicationBlocks combined with your ByteFX (version
> >0.7.6.15073).  This ensure I'm opening and closing connection
> >efficiently and effectively.  However, the pool doesn't reuse,
release
> >connections and gets exhausted at 1000 open connections.  So it must
be
> >a bug in the Connector.
> >
> >Darren Hill
> >darren@stripped
> >Tel: [phone] ext. 2
> >Toll Free: 866-410-1154 ext. 2
> >Fax: [phone]
> >
> >
> >
> 
> 
> 
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:
http://lists.mysql.com/dotnet?unsub=1


-- 
MySQL on .NET Mailing List
For list archives: http://lists.mysql.com/dotnet
To unsubscribe:    http://lists.mysql.com/dotnet?unsub=1