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