SELECT Query using VBA returning wrong results

Hi all,

I report a bug using ODBC connector through VBA. Assuming I have a table named 'companies' with 3 rows in there.
When doing this query:

sqlQuery = "SELECT DISTINCT idCompany" _

        & " FROM companies" _

rsDB.Open sqlQuery, conDB, adOpenDynamic

Then it returns the correct results:

But when doing a query with more than one field, then

sqlQuery = "SELECT DISTINCT idCompany, name" _

        & " FROM companies" _

rsDB.Open sqlQuery, conDB, adOpenDynamic

The query returns this:

This means that any query with more than one field selected returns the first row twice, and doesn't show the last row. Even with more than 20+ rows in my table the result is the same...

Any idea of the origin of this bug?

Thanks a lot

– EDIT –
Here is the connection string used in VBA:

Set conDB = New ADODB.Connection

Set rsDB = New ADODB.recordSet

Set rsDBCol = New ADODB.recordSet

conDB.connectionString = "DRIVER={MariaDB ODBC 3.1 Driver};" _

    & "SERVER=server-1;" _

    & "DATABASE=db_pricing;" _

    & "PORT=3306" _

    & "UID=xuser;" _

    & "PWD=xxxxxxxxxxx;" _

    & "OPTION=3"

conDB.Open

'rsDB.CursorLocation = adUseServer

'rsDBCol.CursorLocation = adUseServer

I've figured out that the use of 'rsDB.CursorLocation=aduseServer' is the cause of the issue. When commenting these 2 lines, my requests seems to work well.