MySqlLoader problems

MySqlLoader problems

Postby vikramka » Sat 10 Sep 2005 04:25

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
vikramka
 
Posts: 2
Joined: Sat 10 Sep 2005 04:15

Postby Serious » Mon 12 Sep 2005 07:09

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

Postby vikramka » Tue 13 Sep 2005 13:27

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.
vikramka
 
Posts: 2
Joined: Sat 10 Sep 2005 04:15

Postby Serious » Tue 13 Sep 2005 13:45

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


Return to dotConnect for MySQL