java连接VF问题 急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急

[sukeqiang]

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String strurl = "jdbc:odbc:Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB="c:\a.dbf";Exclusive=No;"
Connection conn=DriverManager.getConnection(strurl)
sql="select * from a";
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery(sql);
为什么报
[Microsoft][ODBC Visual FoxPro Driver]File 'a.dbf' does not exist.

[十豆三]

ODBC方式：

数据库表
Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;
自由表
Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;Exclusive=No;Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;

[十豆三]

ADO方式:

标准连接:
"Provider=vfpoledb;Data Source=C:\DatabasePath\MyDatabase.dbc;"
或
"Provider=VFPOLEDB.1;Data Source=d:\temp;Password="";Collating Sequence=MACHINE"
或
"Provider=VFPOLEDB.1;Data Source=\\192.168.0.1\zz;Password="";Collating Sequence=MACHINE"
或
"provider=VFPOLEDB.1;data source=d:\;user id=admin;password="
或
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.168.0.1\zz;Extended Properties=dbaSE 5.0;Persist Security Info=False"

[LAIYANGPJ]

c:\a.dbf改成c:/a.dbf试试