Devart Forums

Can someone please help me with this problem...

I am using MySqlLoader to try and load some data into the tables and I get this error

Mesg: Table storage engine for 'tablename' doesn't have this option
InnerExeption:
Source: CoreLab.MySql
StackTrace: at CoreLab.MySql.MySqlLoader.b()
at CoreLab.MySql.MySqlLoader.a(Boolean A_0)
at CoreLab.MySql.MySqlLoader.Close()
at MyProj.BL.DataLoadManager2.LoadPData(Int32 start, Int32 end, MySqlCon
nection conn) in c:\projects\new\myproj.bl\dataloadmanager2.cs:line
59

My tables are running on InnoDb engine.
Help will be much appreciated.

REgards

You have to set MySqlLoader.Delayed = false.
For more information see MySqlLoader.Delayed property reference.

Thanks for the info. I will try it out.
Just for info. what does MySqlLoader use under the covers to load the data. I mean why is it faster than using mysqlCommand.

MySqlLoader is faster due to optimized query data storage and using low internal levels of MySQLDirect .NET.