Bug #84637 'MySqlProv' failed with no error message available, result code: E_FAIL(0x800040
Submitted: 24 Jan 2017 12:18
Reporter: Elmar Knodt Email Updates:
Status: Open Impact on me:
None 
Category:Connector / ODBC Severity:S4 (Feature request)
Version:5.6 OS:Windows (7 Ultimate 32)
Assigned to: CPU Architecture:Any
Tags: Distinct Query problem

[24 Jan 2017 12:18] Elmar Knodt 
Description:
"SELECT DISTINCT champ6 FROM Products" doesn't work with Cherry OleDB driver for MySQL database. Same query works fine with ODBC connection!!

How to repeat:
                        if (CustomerOleDBConnection)
                        {
                            // Query pour rechercher les noms
                            SQLQuery = new OleDbCommand("SELECT DISTINCT champ6 FROM Products", MyDB_InputTable);
                            //SQLQuery = new OleDbCommand("SELECT * FROM `ar_database`.`products` WHERE (`OPC` = '" + 0011357936
                            //    + "')", MyDB_InputTable);
                            //Récupère la liste de la BD dbo.BDG
                            myBDClicheList = SQLQuery.ExecuteReader();
                        }
                        else
                        {
                            // Query pour rechercher les noms
                            SQLQuery_ODBC = new OdbcCommand("SELECT DISTINCT champ6 FROM Products", MyDB_InputTable_ODBC);
                            // Récupère la liste de la BD dbo.BDG
                            myBDClicheList = SQLQuery_ODBC.ExecuteReader();
                        }