//部分源代码如下:
//Base为某数据库的数据源
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Base");
DatabaseMetaData dbmd=con.getMetaData();
ResultSet rs=dbmd.getSchemas(); //这段代码好象执行不了!运行后给出的错误提示如下:
init:
deps-jar:
Compiling 1 source file to F:\java\Connectiong\build\classes
compile-single:
run-single:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]可选的功能未实现
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
[Microsoft][ODBC Microsoft Access Driver]可选的功能未实现
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:5519)
at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(JdbcOdbcDatabaseMetaData.java:2395)
at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getSchemas(JdbcOdbcDatabaseMetaData.java:2444)
at connectiong.Main.main(Main.java:45)
生成成功(总时间:10 秒)
//Base为某数据库的数据源
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Base");
DatabaseMetaData dbmd=con.getMetaData();
ResultSet rs=dbmd.getSchemas(); //这段代码好象执行不了!运行后给出的错误提示如下:
init:
deps-jar:
Compiling 1 source file to F:\java\Connectiong\build\classes
compile-single:
run-single:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]可选的功能未实现
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
[Microsoft][ODBC Microsoft Access Driver]可选的功能未实现
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:5519)
at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(JdbcOdbcDatabaseMetaData.java:2395)
at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getSchemas(JdbcOdbcDatabaseMetaData.java:2444)
at connectiong.Main.main(Main.java:45)
生成成功(总时间:10 秒)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dburl ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\db1.mdb";
Connection conn = DriverManager.getConnection(dburl);
}catch (Exception ex) { }