Accessing MS Access Database using Java

Question

            try{
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                String database = 
          "jdbc:odbc:Driver={MS Access Database (*.accdb)};DBQ=obn.accdb;";
        c= DriverManager.getConnection(database, "", "");
        s=c.createStatement();
                    string = "IN TRY";
                    s.close();  // Close the statement
                    c.close(); // Close the database. Its no more required
                    JOptionPane.showMessageDialog( null, string );

            }
            catch(Exception e)
            {
                string = "IN exception";
                JOptionPane.showMessageDialog( null, string );
            }

I have tried accessing a MS Access Database using Java using the above code always have an Exception. I have tried a few things

            c= DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=obn.mdb");
            s=c.createStatement();

In the first one and the second i get exception -

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

...

                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        c= DriverManager.getConnection("jdbc:odbc:obn");
        s=c.createStatement();

Tried doing this like this, adding OBN in ODBC Datasources(32-bit) in windows , selecting the path to the database. But it didnt work either.

It gave the error

The specified DSN contains an architecture mismatch between the Driver and Application

I Normally dont use MS Access but i have to for a University Project

Gord Thompson · Accepted Answer · 2013-07-19 13:18:43Z

1

Verify that you are using the correct ODBC driver name for your environment. You need to specify either...

{Microsoft Access Driver (*.mdb)}

...or...

{Microsoft Access Driver (*.mdb, *.accdb)}

...depending on whether you want to use the older "Jet" driver (only for .mdb files, available to 32-bit applications only) or the newer "ACE" driver (.mdb or .accdb files, can be used by 32- or 64-bit applications, may need to be installed separately if the machine does not already have Access on it).

edited Jul 19, 2013 at 13:18

answered Jul 19, 2013 at 13:10

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

XuryaX Over a year ago

Driver Keyword Syntax Error is what i get when i try {Microsoft Access Driver (.mdb, *.accdb)} or {Microsoft Access Driver (.accdb)}

XuryaX Over a year ago

c= DriverManager.getConnection("jdbc:odbc:obn"); I think there's mismatch between 64 bit, 32 bit here

XuryaX · Accepted Answer · 2013-07-20 01:18:47Z

0

I found a solution.

connecting using this is correct. c= DriverManager.getConnection("jdbc:odbc:obn"); The database has to be added under odbc in windows administrative tools. Since there is no 64 bit driver, 32 bit driver has to be used. Since 32 bit odbc driver is being used we cant use 64 bit JVM, so changing the JVM from 64 bit to 32 bit from the project manager does the trick , and now it works fine

answered Jul 20, 2013 at 1:18

XuryaX

411 silver badge7 bronze badges

Collectives™ on Stack Overflow

Accessing MS Access Database using Java

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related