2 messages in com.mysql.lists.dotnetRE: [SPAM]Re: Fastest connection type...
FromSent OnAttachments
Darren Hill30 May 2006 10:49 
Jorge Bastos30 May 2006 11:37 
Subject:RE: [SPAM]Re: Fastest connection type ...
From:Darren Hill (dhi@ormac.com)
Date:05/30/2006 10:49:01 AM
List:com.mysql.lists.dotnet

Thanks for the response, but isn't this directly related to connector issues? I mean, everything works great via a TCP connection, I move to a faster 'named pipe' connection and I get this error. Leads me to believe I've done something wrong with the connection, since it's the only thing that's changed, no?

________________________________________ Darren Hill - dhi@ormac.com Ormac Content Management and IT Solutions www.ormac.com

(416) 410-1154 Ormac is proud to partner with: Allstream - www.allstream.com Route1 - www.route1.com

________________________________________

_____

From: Emanuel Oliveira [mailto:eman@gmail.com] Sent: May 30, 2006 1:44 PM To: LIST_mySQL_NET Cc: dhi@ormac.com Subject: [SPAM]Re: Fastest connection type ...

Ok,

* Maybe you should check Online Documentation (searching for "named pipes stored procedures" in version 4.1.x):

* <http://dev.mysql.com/doc/mysql/search.php?q=named+pipes+stored+procedures&b ase=http%3A%2F%2Fdev.mysql.com&lang=en&version=4.1&doc=1-4.1&m=o> http://dev .mysql.com/doc/mysql/search.php?q=named+pipes+stored+procedures&base=http%3A %2F%2Fdev.mysql.com&lang=en&version=4.1&doc=1-4.1&m=o

* Also, I think you are OT (out of topic) posting on this .NET list, which is related only to .NET Connector issues. What you really need is to go for general mySQL server Forums and start looking for "named pipes" vs "stored procedures" help, in order to help others at the same time you start getting tips.

Cheers and Good Luck ~

Emanuel Oliveira

On 5/30/06, Darren Hill <dhi@ormac.com> wrote:

Ok,

I switched to named pipes, and now all my stored procedures are returning this error.

PROCEDURE XXX.XXXX can't return a result set in the given context

Thoughts?

________________________________________ Darren Hill - dhi@ormac.com Ormac Content Management and IT Solutions www.ormac.com

(416) 410-1154 Ormac is proud to partner with: Allstream - www.allstream.com Route1 - www.route1.com

________________________________________

don't know by head, but i know that is on the documentation in the connection string part (if im not wrong)

----- Original Message ----- From: "Chris Herridge" <chr@herridge.co.uk> To: "Jorge Bastos" < <mailto:mysq@decimal.pt> mysq@decimal.pt> Sent: Tuesday, May 30, 2006 4:43 PM Subject: RE: Fastest connection type ...

whats the conection string for a pipe using the .bet connector? i've always wanted to try it!

pipes

Quick one for you all,

I've got a client hosting their web app and MySQL on the same server. What connection type offers me the fastest speed? First answer gets a prize.

________________________________________ Darren Hill - dhi@ormac.com Ormac Content Management and IT Solutions www.ormac.com

(416) 410-1154 Ormac is proud to partner with: Allstream - www.allstream.com Route1 - www.route1.com

________________________________________