I tried to find out if I can use MySQL as the Repository under Servoy R2 2.0 Beta 6, finally found this: http://forum.servoy.com/viewtopic.php?t=302 , which seems to be a good answer.
While searching, I seemed to see lots of questions about which features, drivers, etc. worked with which versions of Servoy and which versions of the various RDBMS.
If it’s not already listed someplace, I think a prominantly displayed, frequently updated, comprehensive “current RDBMS status” matrix of which features are suported with which RDBMSs, with which versions of Servoy, and notes about (or links to) how to implement and any known issues might be extremely helpful.
Well connecting to a database is quite easy and I don’t know to which questions/issues you are referring, the steps to take are:
-check your database version
-check if your database supports JDBC 1.0 or higher (99.5% of databases do)
-download the JDBC driver from the database vendor for that database version
-place the JDBC driver in the Servoy ‘drivers’ directory
-read the documentation from the JDBC driver for how to setup a JDBC URL and which JDBC driver class name to use.
-create a new db server in Servoy and specify url/classname and the username/password needed tobe able to connect
If your database is running and is accessible, your are done.
There are of course more advanced options which you can specify in the JDBC url of some drivers like char encoding etc. (consult the vendor JDBC manual for such options)