473,803 Members | 3,518 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3674
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.c omwrote:
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.c omwrote:
>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
2675
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 quotation madness stemming from the typelessness of the shell language. When using Python as a shell replacement I often launch apps from Python and use different piping constructs to pass data to/get data from these apps. I expect from the language...
2
1876
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 fileObject.readline() then it halts the program if the sub-process is waiting for user input; will executing the readline() part in a seperate thread be helpful? My target platform is Windows. Links to helpful web resources and sample Python codes...
4
2542
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; typedef void(*procedure)();
3
21403
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 ] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
1
1389
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 together arbitrary commands?
3
4246
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 purchase.dat with values: gameboy 149.99 1 ipod nano 220.99 2 DVD-player5 60.95 1
1
3060
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 ! Thank You Antony AtoZ
4
1323
by: samit | last post by:
I keen to persue coding like yahoo piping system which will include drag and drop and piping features
0
1464
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 help at all would be greatly appreciated. #include <stdio.h> #include <stdlib.h> #include <string.h> #include <unistd.h> #include <sys/types.h> #include <sys/wait.h> #include <signal.h>
0
10542
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10289
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10068
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9119
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7600
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5496
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4274
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3795
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2968
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.