locked
Accessing a Java Database from Access RRS feed

  • Question

  •  I have a HSQLDB Database in Java which I want to access from SQL Server or Access. As far as I can make out Microsoft does a driver which lets you read an SQL Server database from Java but not the other way round. Is this correct? Or have I missed something?
    Sunday, November 20, 2011 1:06 PM

Answers

  • You are correct that Microsoft doesn't distribute an HSQLDB driver.  It is the responsibility of the database vendor to distribute ODBC/JDBC drivers or OLE DB providers for use with their database software.

    I see on the HSQLDB web site (http://hsqldb.org/web/hsqlDevelopment.html) that ODBC driver development is in the works but it doesn't seem to be active since the last SVN version of the ODBC files are nearly 2 years old.  I'm guessing the open source development team is concentrating their efforts on the database engine rather than connectivity from languages other than Java.  They are apparently looking for volunteers to help with ODBC so feel free to jump in.

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Proposed as answer by Papy Normand Sunday, November 20, 2011 7:47 PM
    • Marked as answer by MikeHales Sunday, November 20, 2011 8:35 PM
    Sunday, November 20, 2011 3:23 PM

All replies

  • You are correct that Microsoft doesn't distribute an HSQLDB driver.  It is the responsibility of the database vendor to distribute ODBC/JDBC drivers or OLE DB providers for use with their database software.

    I see on the HSQLDB web site (http://hsqldb.org/web/hsqlDevelopment.html) that ODBC driver development is in the works but it doesn't seem to be active since the last SVN version of the ODBC files are nearly 2 years old.  I'm guessing the open source development team is concentrating their efforts on the database engine rather than connectivity from languages other than Java.  They are apparently looking for volunteers to help with ODBC so feel free to jump in.

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Proposed as answer by Papy Normand Sunday, November 20, 2011 7:47 PM
    • Marked as answer by MikeHales Sunday, November 20, 2011 8:35 PM
    Sunday, November 20, 2011 3:23 PM
  • Thanks for that. I ended up writing a piece of Java code which reads the database and then spits it out as an Access database. I just wanted to check that I hadn't missed something really stupid.
    Sunday, November 20, 2011 8:34 PM