2 Replies Latest reply on Jan 19, 2004 4:08 PM by Victor Rotaru


    Richard Bottoms Newbie


      "rbottoms" wrote:
      "rbottoms" wrote:
      "rbottoms" wrote:
      Could someone detail the steps to connect to an Access databases under Jboss 3.0 and Windows XP?


        • 1. Re: msaccess-service.xml
          Stjepan Brbot Newbie


          "sbrbot" wrote:
          "sbrbot" wrote:
          "sbrbot" wrote:
          AFAIK Microsoft Access database one can access from Java only through Type I JDBC driver i.e. JDBC-ODBC bridge. So you have to define ODBC datasource (DSN) on your computer and access this datasource using bridge driver provided by Sun.

          In %JBOSS_HOME%/docs/examples/jca you can find an example of msaccess-ds.xml configuration file and see how to do it.

          Define this file according to the name of your DSN and deploy it under deploy directory of your JBoss application server.


          • 2. Re: msaccess-service.xml
            Victor Rotaru Newbie


            "vrotaru" wrote:
            "vrotaru" wrote:
            "vrotaru" wrote:
            Go to: http://servlet.java.sun.com/products/jdbc/drivers and search:
            There are a couple of companies selling JDBC drivers for Access.
            Jdbc-Odbc bridge is just for playing. Don't even think of using it in production.