Hello,
I tryed to evaluate the viability of SDR with MySQL.
The actual error with MySQL was a problem for me since it is a very present database engine.
First, i tryed to use OLE wrapper to ODBC. It seems the framework does not allow this and throw an error related to use ODBC namespace instead of oledb.
Second, i tryed to use existing provider ADO.NET. My coding skills and the time i had to spend on this test was not enough to allow me to make ADO.NET working
Third, i tryed to code ODBC provider, based on the fact syntax between OLE and ODBC are similar. Failed, when i had to get schema properties.
Four, i tryed once again to find an OLE provider for MySQL. I failed 2 weeks ago, but, i succeeded in fidning a suitable !
So, my solution is to install a MySQL OLE DB provider.
You can get here: http://cherrycitysoftware.com/CCS/Providers/ProvMySQL.aspx
1) Install the provider - i used the beta one all seems ok
2) ACTIVATE IT !!!!! it is free, and i spent 1 hour trying to see why the dataset is not filled, while understanding it was because the provider was not activated. The free version is slower, but it is suitable for my needs :)
3) Choose MySQL provider, fill the fields (DO NOT forget to check "save password"), test connection to be sure
Enjoy ! you can now continue your report configuration.