Unfortunately Reggie, I haven't delved into it too much. I'd like to
get to the core of the problem before actually 'claiming' it's a bug.
Essentially, I was able to call GetParameter("@username" username)
before (using ByteFX), and never needed to specify its type. But using
the MySql.Data it claims the input parameter is of wrong type, and I
noticed it was trying to cast it to a Decimal. So, I simply overloaded
the GetParameter method to allow me to specify the type and all is well.
Darren Hill
darren@stripped
Tel: 416-410-1154 ext. 2
Toll Free: 866-410-1154 ext. 2
Fax: 905-873-6685
-----Original Message-----
From: Reggie Burnett [mailto:reggie@stripped]
Sent: October 28, 2004 4:27 PM
To: darren@stripped; dotnet@stripped
Subject: RE: Connection Pooling
Can you further explain the GetParameter issue?
> -----Original Message-----
> From: Darren Hill [mailto:darren@stripped]
> Sent: Thursday, October 28, 2004 2:46 PM
> To: dotnet@stripped
> Subject: RE: Connection Pooling
>
> 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: 416-410-1154 ext. 2
> Toll Free: 866-410-1154 ext. 2
> Fax: 905-873-6685
>
>
> -----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: 416-410-1154 ext. 2
> > Toll Free: 866-410-1154 ext. 2
> > Fax: 905-873-6685
> >
> >
> > -----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: 416-410-1154 ext. 2
> > >Toll Free: 866-410-1154 ext. 2
> > >Fax: 905-873-6685
> > >
> > >
> > >
> >
> >
> >
> > --
> > 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
>
>
>
>
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:
http://lists.mysql.com/dotnet?unsub=1
