代码:
package com.Icesoft.access;import java.sql.*;public class ExportData {
public static void main(String args[]) {
try {
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(DBDriver);
} catch (java.lang.ClassNotFoundException e) {
e.printStackTrace();
} Connection conn = null;
String url = "jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=D:\\Access\\test.mdb";
try {
conn = DriverManager.getConnection(url);
} catch (Exception ex) {
ex.printStackTrace();
}
}
}控制台信息:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.Icesoft.access.ExportData.main(ExportData.java:17)什么原因呢?URL是在网上查的。
package com.Icesoft.access;import java.sql.*;public class ExportData {
public static void main(String args[]) {
try {
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(DBDriver);
} catch (java.lang.ClassNotFoundException e) {
e.printStackTrace();
} Connection conn = null;
String url = "jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=D:\\Access\\test.mdb";
try {
conn = DriverManager.getConnection(url);
} catch (Exception ex) {
ex.printStackTrace();
}
}
}控制台信息:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.Icesoft.access.ExportData.main(ExportData.java:17)什么原因呢?URL是在网上查的。
1.JAVA的\\表示路径中的一个\,,所以你在写D:\\Access\\test.mdb
要写成"jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=D:\\\\Access\\\\test.mdb"
第二种:到控制面板->管理工具->数据源,,,配下数据源....不要用直接读取方式
应该就可以吧