The directory is being created by Labview and data is written out by MySQL.
Can it be this? I am using windows 2000.

And that reminded me, do I have to create the directory that I will output
the file? Or, MySQL will automaticly create it if not exits???

Regards..



----- Original Message ----- 
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "Mysql General (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, October 21, 2004 10:35 PM
Subject: RE: SELECT... INTO OUTFILE problem


[snip]
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...
[/snip]

It is a permissions problem, make sure that directory is writable.

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




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

Reply via email to