Problem to connect to index columns

[Trentesaux Mathieu]

Hello

I'm now using ADO, ADOX to access my MySQL database thru the ODBC driver 5.1. All works fine except that I can't access the column index definition.

When I execute

Dim adoTable As ADOX.Table
Dim adoIndex As ADOX.Index
Dim adoColumn As ADOX.Column

-For Each adoTable In adoCatalog.Tables
--For Each adoIndex In adoTable.Indexes
---For Each adoColumn In adoIndex.Columns

I receive the error 3251 "operation is not supported for this type of object" when executing the last line. It is the same with :

--x= adoIndex.Columns.Count

All other access to objects works normally with Indexes, Index.Properties, Tables, Table.Columns Column.Property...

I did try this with ADO/ADOX 2.6 and then 6.0

This problem seems to be coming from the MySQL driver, but... If it would be the case I certainly shall find some occurences of it on the Net, but it is not the case... I don't understand.