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

Re: Piping

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 wrote:
> 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

Re: Piping

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, torpecool@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 wrote:
>> 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
>