Piping

[moti]

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

[t***@yahoo.com]

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.

Post by moti
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

[moti]

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

Post by t***@yahoo.com
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.

Post by moti
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