Click here to get back home

Piping

 HomeNewsGroups | Search | About
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Piping moti 02-02-2007
Get Chitika Premium
Posted by moti on February 2, 2007, 2:38 pm
Please log in for more thread options
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

Posted by torpecool on February 2, 2007, 4:16 pm
Please log in for more thread options
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.


> 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



Posted by moti on February 5, 2007, 3:33 pm
Please log in for more thread options
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.
>
>
>> 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
>


Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap