String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; Class.forName(driver); String url = "jdbc:odbc:Driver={Microsoft Visual FoxPro Driver}; SourceType=DBF; SourceDB=d:\\bc.dbf; Exclusive=No"; conn = DriverManager.getConnection(url); 在程序里执行上面的代码后,出现如下错误:java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 驱动程序不支持此功能 at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323) at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:193) at TestUint.main(TestUint.java:20)
String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; String url = "jdbc:odbc:DRIVER={Microsoft dBase Driver (*.dbf)};DBQ=d:/report/bh.dbf"; Connection conn = DriverManager.getConnection(url,"",""); Statement stat = conn.createStatement();报如下错误:java.sql.SQLException: [Microsoft][ODBC dBase Driver] '(未知的)'不是一个有效的路径。 确定路径名称拼写是否正确,以及是否连接到文件存放的服务器。 at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323) at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at TestUint.main(TestUint.java:26)
楼主【chenxiaoying】截止到2008-06-24 21:15:14的历史汇总数据(不包括此帖):
发帖数:7 发帖分:200
结贴数:3 结贴分:90
未结数:4 未结分:110
结贴率:42.86 % 结分率:45.00 %
楼主该结一些帖子了
Class.forName(driver);String url = "jdbc:odbc:Driver={Microsoft Visual FoxPro Driver}; SourceType=DBF; SourceDB=d:\\bc.dbf; Exclusive=No"
conn = DriverManager.getConnection(url);
Class.forName(driver); String url = "jdbc:odbc:Driver={Microsoft Visual FoxPro Driver}; SourceType=DBF; SourceDB=d:\\bc.dbf; Exclusive=No";
conn = DriverManager.getConnection(url);
在程序里执行上面的代码后,出现如下错误:java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 驱动程序不支持此功能
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at TestUint.main(TestUint.java:20)
String url = "jdbc:odbc:DRIVER={Microsoft dBase Driver (*.dbf)};DBQ=dbf所在目录;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url,"","");
连上后,用SQL语句去操作DBF,就像操作SQLServer一样,当然一些函数不同。
看我以前的一贴:http://topic.csdn.net/u/20070206/15/82eb015f-a095-4174-b3d2-f70f30dd5a14.html
DBF数据库跟Access一样是以目录的形式存在的我曾经试过用数据源等等后来找了好久才找到一个,解决方法在那个帖子的6楼!
String url = "jdbc:odbc:DRIVER={Microsoft dBase Driver (*.dbf)};DBQ=d:/report/bh.dbf";
Connection conn = DriverManager.getConnection(url,"","");
Statement stat = conn.createStatement();报如下错误:java.sql.SQLException: [Microsoft][ODBC dBase Driver] '(未知的)'不是一个有效的路径。 确定路径名称拼写是否正确,以及是否连接到文件存放的服务器。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at TestUint.main(TestUint.java:26)
String connectionURL = "jdbc:odbc:testdb";Class.forName(driverName).newInstance();
conn = DriverManager.getConnection(connectionURL);
testdb 是odbc数据源的名字