Question

java.sql.SQL Exception:[Microsoft][ODBC Microsoft Access驱动文件] 找不到文件'(未知的)

eclipse 中一运行就出现这个问题

Answer 1

也许是你的ODBC配置错误，我也遇见过，不过后来用Access连接字符串直接连接文件路径就OK啦
//这是2003的连接字符串
// String url =
// "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=F:/Desktop/文档/word/Student.mdb";
//这是2010的连接字符串

String url = "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=F:/Desktop/文档/word/Student.accdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection connection = DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String sql = "select * from Student";

Answer 2

不是提示你去下个odbc驱动吗