title: Connection access database in java program
body: <p>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:</p>
  
  <pre><code>private String dburl="jdbc:odbc:DRIVER={Microsoft Access Driver(*.mdb)};DBQ=Database1.mdb";
  ...
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  c=DriverManager.getConnection(dburl);
  </code></pre>
  
  <p>And I get the folowing error:</p>
  
  <pre><code>Errorjava.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name no t found and no default driver specified
  </code></pre>
  
  <p>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,...</p>
  
  <p>Can someone help me please?</p>