I'm trying to use an OleDbConnection object to extract the schema from a MySql database. I'm using the OleDbConnection.GetOleDbSchemaTable method, which seems to work on other databases but not on MySql.
My connection string is "Server=localhost;Database=test;Uid=gerard;Pwd=pass;"
When I try and open the OleDbConnection object, I get the message:
"No error information available: E_FAIL(0x80004005)."
Can I connect to a MySql database via an OleDbConnection object, or do I need to use a MySqlConnection object? If the latter, how do I extract the schema?