473,322 Members | 1,644 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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 3650
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Csaba Henk | last post by:
For me, one reason for using Python is that with the help of it I can rid of several problems that I faced with during writing scripts in Bourneish shells. Biggest of these problem was the...
2
by: Apple Grew | last post by:
I want to develope a Winboard like application which will support Winboard protocol. For that I require to know how to handle piping in Python. I seperated out module popen2, but when I use...
4
by: christopher diggins | last post by:
I just wanted to share this technique for piping the cout from one function to the cin of another, using the pipe operator: #include <iostream> #include <sstream> using namespace std; ...
3
by: Russ Schneider | last post by:
Is there an easy way to pipe a select statement's output to a file? -- http://www.sugapablo.com <--music ] http://www.sugapablo.net <--personal ] sugapablo@12jabber.com <--jabber IM ]...
1
by: saibotorama | last post by:
What is the Python translation for this Bash statement: tar cf - "${files}" | bzip2 "$file".tar.bz2 (Ignoring the fact that "tar cjf" also exists...) In other words, how does one pipe...
3
by: noob2008 | last post by:
can anyone explain me what is piping in C++ programming? for example invoice.exe < purchase.dat > statement.txt do i replace that where all the cin statements? i created a text file called...
1
by: AtoZ | last post by:
Hello, I'm looking for some experience translation between the software PDMS to Pro/ENGINEER ( Pro/PIPING ) and reverse. If some engineer know the solutions, their feedback will be very usefull...
4
by: samit | last post by:
I keen to persue coding like yahoo piping system which will include drag and drop and piping features
0
by: jsimps44 | last post by:
Hi, I'm fairly new to c, and very new to piping and file descriptors and can't seem to get past this problem. The piping is very much not working, and I can't figure out for the life of me why. Any...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.