Java:连接到MS-Access数据库(mdb或mde) [英] Java: Connect to MS-Access Database (mdb or mde)

问题描述

我正在尝试使用JDBC:ODBC连接到MS-Access:

I am trying to connect to MS-Access using JDBC:ODBC:

public boolean connectToAccess(String accessFilePath) {
    //Get connection to database
    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        myConnection = DriverManager.getConnection("jdbc: odbc: driver={Microsoft Access Driver (*.mdb)};DBQ=" + accessFilePath);
    } catch (Exception ex) {
        System.out.println(ex);
        return false;
    }
    return true;
}

我得到了错误: 找不到适用于jdbc的合适驱动程序:odbc:driver = {Microsoft Access Driver(* .mdb)}; DBQ = file.mdb" 为什么? 您能建议另一种读取Java访问文件的方法吗?

I get the error: "No suitable driver found for jdbc: odbc: driver={Microsoft Access Driver (*.mdb)};DBQ=file.mdb" Why? Can you suggest another way of reading access files in Java?

推荐答案

将这些空格从连接字符串中删除，看看是否有帮助.我还建议打印堆栈跟踪.

Take those spaces out of the connection string and see if that helps. I'd also recommend printing the stack trace.

public boolean connectToAccess(String accessFilePath) {
    //Get connection to database
    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        myConnection = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=" + accessFilePath);
    } catch (Exception ex) {
        ex.printStackTrace();
        return false;
    }
    return true;
}

这篇关于Java:连接到MS-Access数据库(mdb或mde)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！