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
Load Data Infile
Re: Load Data Infile
Now we don't support LOAD DATA LOCAL INFILE in Direct mode.
To use this command add Direct = false to your connection string.
To use this command add Direct = false to your connection string.