mysql and named pipes

Thread view:

Paul Battersby - 03 May 2005 05:27 GMT

I'm using Win2000 and I want to use named pipes instead of a TCP/IP
connection to MySql.

I'm using the following connection string:

jdbc:mysql://localhost/?enable-named-
pipe&socket=MySQL&socketFactory=com.mysql.jdbc.NamedPipeSocketFactory

And I get the following error:

java.io.FileNotFoundException: \\.\pipe\MySQL (The system cannot find the
file specified)

Any idea what I'm doing wrong?

Reply to this Message

Mark Matthews - 03 May 2005 17:00 GMT

> I'm using Win2000 and I want to use named pipes instead of a TCP/IP
> connection to MySql.
[quoted text clipped - 10 lines]
>
> Any idea what I'm doing wrong?

Paul,

You need to start the server with --enable-named-pipe.

Regards,

-Mark

Signature

Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com

Reply to this Message

Paul Battersby - 03 May 2005 18:51 GMT

> You need to start the server with --enable-named-pipe.

When I open up MySql Administrator, under Service Control/Configure
Service/Server Features the "named pipes" option is checked (mysql has been
started and stopped many times since this was first set) .

I looked in the my.ini file and saw no mention of named pipes so I added the
line.

enable-named-pipe

and now it works.

Thanks.

Reply to this Message

mysql and named pipes

Free Magazines