Error msg: Select keyword not found

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

Error msg: Select keyword not found

Post by profixio » Tue 12 Dec 2017 09:05

Hi!
This is a printscreen from an error which we cant get rid of:
http://sharing.profixio.com/uploads/dev ... -59-50.png

The table certainly has "id" as a column.

/Ole

Shalex
Site Admin
Posts: 9543
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;
        table.Open();
    }
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