Page 1 of 1

Load Data Infile

Posted: Thu 20 Jan 2005 16:06
by tony lehtola
I am having a problem with the load data MySql command. I can run queries successfully with the load data infile command, but the moment I try to use the LOCAL argument, I get the method not supported message. Is the local arguement not accepted through MySqlDirect, and if not, is there another way I can achieve the same functionality without resorting to mapping a drive and copying the source?

LOAD DATA LOCAL INFILE 'C:/perfsource.txt' into table performer_ins;

Error: CoreLab.MySql Specified method is not supported.

Thanks

Re: Load Data Infile

Posted: Fri 21 Jan 2005 09:14
by Oleg
Now we don't support LOAD DATA LOCAL INFILE in Direct mode.
To use this command add Direct = false to your connection string.