Load Data Infile

Load Data Infile

Postby tony lehtola » Thu 20 Jan 2005 16:06

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
tony lehtola
 

Re: Load Data Infile

Postby Oleg » Fri 21 Jan 2005 09:14

Now we don't support LOAD DATA LOCAL INFILE in Direct mode.
To use this command add Direct = false to your connection string.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for MySQL