title: java.sql.SQLException: No suitable driver found for jdbc:odbc:Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=D:\Users\
body: <p>i need help with the ODBC - JDBC Interface for CSV, with 32Bit Java 1.7.0_72</p>
  
  <p>i recieved this code</p>
  
  <pre><code>    private void connectToCSV(String file) {
      try {
          debug.println(path + file +" "+this.file);
          if (this.file == null){
              this.file = file;
  
              gfdiConnection = DriverManager.getConnection("jdbc:odbc:Driver={"+ driverCSV + "};DBQ=" + path );
  
          }
          if (this.file != file){
  
          this.file = file;
          gfdiConnection = DriverManager.getConnection("jdbc:odbc:DRIVER={" + driverCSV + "};DBQ=" + path);
          }
      } catch (SQLException e) {
          debug.println("Error while trying to connect to CSV");
          e.printStackTrace();
      } 
  }
  </code></pre>
  
  <p>but I didn't get run it. </p>
  
  <pre><code>java.sql.SQLException: No suitable driver found for jdbc:odbc:Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=D:\Input\
  </code></pre>
  
  <p>I found a suggestion with </p>
  
  <pre><code>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  gfdiConnection = DriverManager.getConnection("jdbc:odbc:Driver={"+ driverCSV + "};DBQ=" + path );
  </code></pre>
  
  <p>but this didn't work here. </p>
  
  <pre><code>java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
  </code></pre>
  
  <p>I checked also the Driver Name with </p>
  
  <pre><code> C:\Windows\SysWOW64\odbcad32.exe 
  </code></pre>
  
  <p>so whats the Problem with the Driver ?</p>