Is it possible to access an HSQLDB database that is running in server mode from a .net application located on the same computer? There do not seem to be any odbc drivers for hsqldb (freely available). Am I missing it?
Sun's jdbc odbc bridge seems to allow connecting to an odbc datasource through a jdbc connection, but I would need the opposite in this case: to be able to create a odbc connection that would bridge me to a jdbc source.
Thanks!
Some solutions from Google:
Run H2, which is based off hsqldb. Then, use it via postgresql drivers.
According to their website hsqldb.org:
.NET and ODBC developments:
HSQLDB core developer, Campbell Boucher-Burnet has developed a .NET port of HSQLDB 1.8.x. The development is in its late stages. Other core developer, Blaine Simpson has been developing an ODBC driver for HSQLDB 2.0. This currently works for direct statements and supports Windows and Linux. Code for both efforts can be downloaded from the SVN repository.
So you might want to check their SVN repository.
Realizing that the author of the original post might already have his solution, I think it might be helpful to others to add on to this thread. Although our solution is not free, our SimbaEngine SDK is an extremely fast & efficient way to build a custom driver for your data store. We support both local and client/server access as well as bridging between ODBC, JDBC and ADO.NET components. You can get a free evaluation version of it at http://www.simba.com/evaluate-odbc-sdk.htm.