Has anyone ever succeeded in using mysql instead of ms sql with the results repository? I am already using mysql to drive my tests and provide init. info, etc. and would prefer to stick with one db should I try to use the results repository.
Aside from the repository has anyone had any luck putting results files on a web server? Any chance someone was clever enough to get the embedded links to work, too?
The Result Repository, if I recall correctly, just uses standard SQL, with no sub-queries, so sould work with mySQL. You might need to change a few things for creating the database, but should be straight forward.
I do not use the Result Repository. Instead, I use my own logging which logs the results to the Result file and to an HTML file, with the ability to have files linked to the log, and color-coded errors and warnings. Also have URL's linked in the file, to open in a new window. I posted the code for that here a few weeks ago - search on logClass if intersted.
Using another database is fine. Just change the ODBC driver to point at another database. One caveat....The SQL statements for one database "might" not entirely work of another. I've had it working with MySQL though. The key is to make sure that the database you are going to use has a DSN, a user account with CREATE DATABASE rights and that this information is set into the following variables in the SilkTestRepository.inc file that ships with SilkTest. (If you have an older version that doesn't ship this, UPGRADE!)