Hi,

I am sending a query to a MySQL server on a network via LabView EXEC QUERY
VI.

It looks like that

SELECT  `data1` ,  `data2`
INTO  OUTFILE  'C:\\data_out\\day234\\data_out.txt'
FIELDS  TERMINATED  BY  '\t'
OPTIONALLY  ENCLOSED  BY  '"'
LINES  TERMINATED  BY  '\r\n'
FROM data_table;


What I get as a result is

Exception occured in Microsoft OLE DB Provider for ODBC Drivers,
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Can't create/write to file
'C:\data_out\day234\data_out.txt' (Errcode: 2)


So I copy the query statement and send via PhpMyAdmin, it ended up as below
#1 - Can't create/write to file 'C:\data_out\day234\data_out.txt' (Errcode:
2)

So it is not a problem of Labview BUT my SQL statement...

Do I do something wrong?

Regards...


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to