Using test complete with a HSQL database

Do you have an ODBC driver for that HSQL database server? If so then you just need a connection string, and you access the data the same way you do any other ODBC database.

Goodle ADO. It is an ActiveX database connectivity technology (oldish) that you can get to any ODBC or ADO cimpliant database with.

Cheers Stephanie, but it seems like ADO will not be the answer here as it's not got any connection strings it'll be happy with.



Hugo, thanks for the ODBC advice.  That was the suspected path we'd need to use ultimately.  However, HSQLDB doesn't seem to keep ODBC drivers up-to-date.  I found some really old ones, but now come across the problem that they can't work with 1.8 HSQL and an upgrade to 1.9 is required...so much more searching needed.

After reading a bit more about HSQL, it only seems to be designed for access from a JVM, there are no ODBC drivers for it, but there is a Java equivalent driver (JDBC).



Seems like a sketchy product TBH, I wouldn't be caught using this in 100 years. There are plenty of standard DBMS products out there, I doubt HSQL has anything that's not available in SQL Server Express.



If the product you are testing is forced to use this, I guess you are out of luck and will probably have to resort to filthy tricks in the end. I would pass the message upstairs that SQL Server Express is free. If not that, then SQLite, MySQL, etc..