As many of you may have read in other posts I have been asking for MySQL support for a while and fortunately and unfortunately the time arrived where I had the need to communicate with Visual FoxPro and MySQL databases from the same StrataFrame project.



Thanks to comments and code from Keith Chisarik, Bill Cunnien, Greg McGuffey and other related posts I found from Trent Taylor (from SF Team) I was able to create a MySQLDataSourceItem.vb class attached (in VB only sorry ). Due to time constraint I just added some comments to the class and tested the functionality to Read, Add, Modify without stored procedures, just the simple stuff needed for this project.



I am using the MySQLConnectorclass version 6.3 with has a very good documentation and so far many of the method/properties found in the MS-SQL connector exist in the MySQL connector and that made it easier to translate the original base class.



Still none of the SF tools Connection Manager class, DDT & BOM works with MySQL using the .Net connector, only the OleDB seems to be supported and I did not try the OleDb. I had to create my own Connection Manager form which was not that complicated since MySQLConnector have a MySqlConnectionStringBuilder as well so that made it easier.



Talking about Connection String Builders, Trent, I don't know if you are aware that MS released the code the use for their Data Connection Dialog to create string connections for any database supported by Visual Studio. I could assume that if the SF team uses this code in the SF Connection Manager then you could allow the developer to connect to any database using the SF tools, of course we would need to create the Data Source Item required making SF more generic for the developer's need.



Sorry for the long post and I hope other SF developers can benefit from this experience. Now getting ready to work with VistaDB.



P.S.

I am still hoping to see direct support for MySQL and VistaDB database from SF soon Business wise it will be really helpful to see serious commitment with some release dates for the new functionality, technology and coming updates to StrataFrame.

Edhy Rijo

Hi Jason,



Thanks for sharing your experiences with MySQL, that looks like a lot of work for any project, it should be easier. I have not tested yet, but I believe in the BOM you can use a MySQL OleDB driver to read the schema for your BOs, if possible, please try and let us know.

Edhy Rijo