Data blog — Setup RSS

Activation of Cherry City Software OLEDB Provider for MySQL

If you read my previous post, How to install MySQL Connection Provider, you know that installation of the provider is just the first step. Yes, you can test the connection, but any attempt to run a query against your MySQL database will result with error saying "MySQL OLE DB provider has not been activated".  I was stuck for a while with this error - it doesn't direct exactly to a resolution of the issue. I analyzed the code of SelectCompare and found nothing wrong with it. I googled for some information pertaining to the error message. I found some old pages that referenced the message, but no solutions.  This made me thinking - after all, if Google doesn't show relevant results, there must...

Continue reading