Devart Forums

I'm a little confused here. I have a large table that I can successfully query from using a MySql client from (for example TOAD) but when I run the exact same query using dotConnect for MySQL I recieve the following error:

Incorrect key file for table 'C:\Users\MYSQLA~1\AppData\Local\Temp\#sqlbb8_255_0.MYI'; try to repair it.

I'm really confused here, any ideas?? I can read other smaller tables in the database, but this one is large (6 million). But like I said, it works fine using TOAD. here is a sample query.

select column1 from table where column1 = 'Y' order by column1 limit 0, 25

This bug was discussed by the MySQL society at http://forums.mysql.com/read.php?21,362974,362974.

Please give us the following information so that we can reproduce the issue in our environment:
1) the DDL/DML script of your table. Contact us via this form;
2) the way you are working with it and your rough connection string (a small test project will be appreciated);
3) the versions of your MySQL Server and dotConnect for MySQL.