Error msg: Select keyword not found

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 3
Joined: Wed 10 Dec 2014 10:04

Error msg: Select keyword not found

Post by profixio » Tue 12 Dec 2017 09:05

This is a printscreen from an error which we cant get rid of: ... -59-50.png

The table certainly has "id" as a column.


Devart Team
Posts: 7964
Joined: Thu 14 Aug 2008 12:44

Re: Error msg: Select keyword not found

Post by Shalex » Thu 14 Dec 2017 20:47

We cannot reproduce the issue with the following code:

Code: Select all

    using (var conn = new MySqlConnection()) {
        conn.ConnectionString = "server=db;port=3311;uid=root;pwd=root;database=test;";

        var table = new MySqlDataTable("select deptno from dept", conn);
        table.FetchAll = false;
        table.NonBlocking = true;
        table.StartRecord = 0;
        table.MaxRecords = 10000000;
1. Make sure that your SelectCommand.CommandText includes SELECT without any non-English letters (retype SELECT).
2. How should we modify this sample to reproduce the issue in our environment?

Post Reply