Hi all,

just pulled ICE 3.1 for Windows and running it on XP x64 but now I’m trying to load data—I have this issue here:

—when I try this:
LOAD DATA LOCAL INFILE ‘C:\ WO.TXT ’ INTO TABLE WO FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’ IGNORE 1 LINES;

I get this:
<eb1>Brighthouse: Session terminated unexpectedly, uncommitted transactions rolled back.
State: S1000; Native: 1402; Origin: [MySQL][ODBC 5.1 Driver] [mysqld-5.1.14-log]</eb1 >

Looked about everywhere on Google and ICE forums/wiki but cant see what the problem is—anything objvious?

Thanks!

ICE doesn’t support the ‘local’ modifier.

Yes and then some

But i got that working now—thanks!