LOAD DATA LOCAL INFILE -> Exception: Not supported field count found

LOAD DATA LOCAL INFILE -> Exception: Not supported field count found

Postby JimJones » Sun 25 Mar 2007 20:39

Hi!

i try to import a .csv file into a mySQL Database using the mysqldirect component. Ihave a DataSet and created a TableAdapter which contains a SQL Statement like

LOAD DATA LOCAL INFILE 'C:\test.csv' INTO TABLE `testimport` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n'

If i use this Statement for example in phpmyadmin it just works fine.. I can't figgure out why :-) I searched a lot in this and other forums but i couldn't find somebody with the same problem...

please help me ;-)

Jim
JimJones
 
Posts: 1
Joined: Sun 25 Mar 2007 20:33

Postby Alexey » Mon 26 Mar 2007 07:38

You are using direct mode, aren't you? Unfortunately we do not support this SQL statement in direct mode. You should use client (Direct=false) mode instead.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL