470,586 Members | 1,349 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,586 developers. It's quick & easy.

Piping

I am a newbie to MySQL.
I'm confused as to the piping syntax of SERVER in the User DSN in ODBC
for a client PC.

If I use an ip it does not work, probably because of a firewall. So I
tried using named pipes and nothing seems to work.
I am running MySQL on a windows xp and all the client PCs are on xp
too.
Named Pipes is checked as well as Enable named pipes and Socket/pipe
name, which is MySQL.
I've tried a dot (.) mysql, \\mysql - none these work. I get Request
returned with SQL_ERROR on odbc 3.51.

Help
Feb 2 '07 #1
2 3439
I'm not sure.... just guessing here.... but this may be a permissions/
privileges issue.

One thing to check is that the user account you are trying to use to
connect your ODBC client to the mysql database is allowed to connect
to the database from ANY HOST. I ran into a similar issue a while ago
and this resolved it for me. No guarantee that it will work for you
but it's something to try.
On Feb 2, 2:38 pm, moti <mot...@gmail.comwrote:
I am a newbie to MySQL.
I'm confused as to the piping syntax of SERVER in the User DSN in ODBC
for a client PC.

If I use an ip it does not work, probably because of a firewall. So I
tried using named pipes and nothing seems to work.
I am running MySQL on a windows xp and all the client PCs are on xp
too.
Named Pipes is checked as well as Enable named pipes and Socket/pipe
name, which is MySQL.
I've tried a dot (.) mysql, \\mysql - none these work. I get Request
returned with SQL_ERROR on odbc 3.51.

Help

Feb 2 '07 #2
I looked into it. I can't even get the server to work with piping
except using a dot. Would you know the syntax?

On 2 Feb 2007 13:16:04 -0800, to*******@yahoo.com wrote:
>I'm not sure.... just guessing here.... but this may be a permissions/
privileges issue.

One thing to check is that the user account you are trying to use to
connect your ODBC client to the mysql database is allowed to connect
to the database from ANY HOST. I ran into a similar issue a while ago
and this resolved it for me. No guarantee that it will work for you
but it's something to try.
On Feb 2, 2:38 pm, moti <mot...@gmail.comwrote:
>I am a newbie to MySQL.
I'm confused as to the piping syntax of SERVER in the User DSN in ODBC
for a client PC.

If I use an ip it does not work, probably because of a firewall. So I
tried using named pipes and nothing seems to work.
I am running MySQL on a windows xp and all the client PCs are on xp
too.
Named Pipes is checked as well as Enable named pipes and Socket/pipe
name, which is MySQL.
I've tried a dot (.) mysql, \\mysql - none these work. I get Request
returned with SQL_ERROR on odbc 3.51.

Help
Feb 5 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Csaba Henk | last post: by
2 posts views Thread by Apple Grew | last post: by
4 posts views Thread by christopher diggins | last post: by
3 posts views Thread by Russ Schneider | last post: by
1 post views Thread by saibotorama | last post: by
3 posts views Thread by noob2008 | last post: by
4 posts views Thread by samit | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.