spawn (with bi-directional pipes) on windows [message #65437] |
Wed, 04 March 2009 08:59 |
Tony
Messages: 6 Registered: March 2009
|
Junior Member |
|
|
Hi all,
I'm having some issues using the 'spawn' command with bi-directional
pipes on a windows vista machine. I am spawning the 'mysql' command,
in order to connect to a database. Specifically, this does not work:
IDL> spawn, 'mysql -B -n -q --host=myhostname.example.com --
user=myusername --password=mypassword mydbname', unit=unit
IDL> printf, unit, 'show tables;'
% PRINTF: Error encountered writing to file. Unit: 111
File: <cmd.exe /c mysql -B -n -q --
host=myhostname.example.com --user= myusername --password= mypassword
mydbname >
The pipe is being closed.
I should mention that reading from the pipe created by the spawn
command seems to work fine.
On a Linux machine, those IDL commands work fine, and I can continue
reading the table names, etc. If I run the command directly from a
command prompt on my windows machine, it also works fine.
Any ideas?
Alternatively, any other ideas for accessing a mysql database from IDL
on a windows machine? My investigation into the 'spawn' command came
from playing around with Marc Buie's IDL routines for mysql.
Thanks,
Tony Case
|
|
|