title: How to connect to Access .mdb database from 64-bit Java?
body: <p>Hi I have the below code to connect to MS Access database on Windows 7 OS. I have changed the Data Source short cut to point to 64bit odbc then 32 bit. But still getting the error as </p>
  
  <pre><code>java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956)
      at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113)
      at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3072)
      at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
      at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
      at java.sql.DriverManager.getConnection(DriverManager.java:579)
      at java.sql.DriverManager.getConnection(DriverManager.java:221)
      at TestDBConnection.main(TestDBConnection.java:21)
  </code></pre>
  
  <p>And my code is :</p>
  
  <pre><code>import java.sql.Connection;
  import java.sql.DriverManager;
  
  public class TestDBConnection {
  
      public static void main(String[] args) {
          // TODO Auto-generated method stub
          try
          {
              System.out.println("filename");
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              String database = 
                        "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\\Test\\Tests.mdb";
              Connection conn = DriverManager.getConnection(database, "", "");
          } catch(Exception ex) {
              ex.printStackTrace();
          }
      }
  
  }
  </code></pre>
  
  <p>How ever I have SQL Workbench tool through which I can connect to it but not through java code. </p>
  
  <p>Please need help badly as I am struggling with this from past 3 hours searching on Google.</p>