Connection access database in java program

Question

I am trying to connect my java program with a MS ACCESS database. I looked a lot on the internet, but I don't find my problem. I wrote the code:

private String dburl="jdbc:odbc:DRIVER={Microsoft Access Driver(*.mdb)};DBQ=Database1.mdb";
...
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
c=DriverManager.getConnection(dburl);

And I get the folowing error:

Errorjava.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name no t found and no default driver specified

I make a DNS from my database. And I tried a lot, but I keep having the error. I also try with the exact location where the database is, I tried to put the created DNS in the folder of my java program,...

Can someone help me please?

Rahul Tripathi · Accepted Answer · 2012-11-03 20:09:13Z

1

If somehow possible, don't use a JdbcOdbc driver, but a pure JDBC-Driver for your database

OR

Try this:-

DriverManager.registerDriver((Driver) 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance());
c= DriverManager.getConnection(dburl,"","");

This will ensure that the "sun.jdbc.odbc.JdbcOdbcDriver" class is loaded and connected to the DriverManager.

answered Nov 3, 2012 at 20:09

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

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

1 Comment

Bigjo Over a year ago

I get the same error with your code. How do I do to use a pure JDBC-driver ?

Mark Rotteveel · Accepted Answer · 2012-11-04 07:19:56Z

1

The error message "Data source name no t found and no default driver specified" is all you need. It can't locate the database Database1.mdb. You might want to try specifying the absolute path to the driver.

answered Nov 4, 2012 at 7:19

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

5 Comments

Bigjo Over a year ago

I already tried with the absolute path, but it doesn't word neither. I wrote dburl="jdbc:odbc:DRIVER={Microsoft Access Driver(*.mdb)};DBQ=C:/Users/Jurgen Decuyper/Documents/Database1.mdb";

Mark Rotteveel Over a year ago

Do you actually have the Access Driver installed?

Mark Rotteveel Over a year ago

You are not using a system DSN in your connection string.

Bigjo Over a year ago

And how do I use a system DSN in my connection string?

Mark Rotteveel Over a year ago

Use jdbc:odbc:<name-of-your-dsn>

Yongxin Zhao · Accepted Answer · 2012-11-12 01:38:41Z

0

How do I do to use a pure JDBC-driver ?

HXTT Access (a commercial pure Java type 4 driver) is at http://www.hxtt.com/access.html .

answered Nov 12, 2012 at 1:38

Yongxin Zhao

1241 bronze badge

Collectives™ on Stack Overflow

Connection access database in java program

3 Answers 3

1 Comment

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related