怎么连接不上FoxPro的.DBF表啊？

[dippergao]

现在只有一个FoxPro表：cj.dbf
采取下面的连接和查询方式：
<%
Set Conndbf=server.createobject("adodb.connection")
Driver = "Driver={Microsoft Visual FoxPro Driver};"
SourceType = "SourceType=DBF;"
DBPath = "SourceDB=" & Server.MapPath("datacenter/cj.dbf")
conndbf.Open Driver & SourceType & DBPath

set rs = server.createobject("adodb.recordset")
sql = "SELECT * FROM cj.dbf"
rs.open sql, conndbf,1, 3
response.Write rs("xm")
%>
执行程序时提示：
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'

ODBC 驱动程序不支持所需的属性。
错误行：rs.open sql, conndbf,1, 3

[dippergao]

谢谢楼上两位朋友帮忙
可是还出错：
<%
Set Conndbf=server.createobject("adodb.connection")
conndbf.Open "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=" &
server.mappath("datacenter/cj.dbf")
%>
<%
set rs = server.createobject("adodb.recordset")
sql = "SELECT * FROM cj"
rs.open sql, conndbf,1, 3
response.Write rs("xm")
%>
提示错误：
[Microsoft][ODBC dBase Driver]常见错误不能打开注册表关键字‘Temporary(volatile)Jet DSN for process 0x5c8 Thread 0x8a0 DBC 0x23e1024 Xbase’。

[dippergao]

UP!

[online]

连结dbf文件
<%
' 建立Connection 对象
Set conn = Server.CreateObject("ADODB.Connection")
Driver = "Driver={Microsoft Visual FoxPro Driver};"
SourceType = "SourceType=DBF;"
DBPath = "SourceDB=" & Server.MapPath( "Dbf" )

' 调用Open 方法连接数据库
conn.Open Driver & SourceType & DBPath

Set rs = Server.CreateObject("ADODB.Recordset")
' 打开数据源，参数二为Connection对象
rs.Open "Select * From sample", conn, 2, 2
%>


'连结foxpro文件
<%
' 建立Connection 对象
Set conn = Server.CreateObject("ADODB.Connection")
Driver = "Driver={Microsoft Visual FoxPro Driver};"
SourceType = "SourceType=DBC;"
DBPath = "SourceDB=" & Server.MapPath( "Dbf/Sample.dbc" )

' 调用Open 方法连接数据库
conn.Open Driver & SourceType & DBPath

Set rs = Server.CreateObject("ADODB.Recordset")
' 打开数据源，参数二为Connection对象
rs.Open "Select * From sample", conn, 2, 2
%>

[online]

建议安装
安装mdac2.6驱动
http://download.microsoft.com/download/dasdk/Install/2.60.6526.3/WIN98Me/EN-US/MDAC_TYP.EXE

http://www.cclis.com/download.asp
Microsoft MDAC支持程序

[dippergao]

<%
' 建立Connection 对象
Set conn = Server.CreateObject("ADODB.Connection")
Driver = "Driver={Microsoft Visual FoxPro Driver};"
SourceType = "SourceType=DBF;"
DBPath = "SourceDB=" & Server.MapPath( "datacenter\cj.DBF" )

' 调用Open 方法连接数据库
conn.Open Driver & SourceType & DBPath

Set rs = Server.CreateObject("ADODB.Recordset")
' 打开数据源，参数二为Connection对象
rs.Open "Select * From gk.dbf", conn, 2, 2

response.Write rs("xm")
%>
出现错误：conn.Open Driver & SourceType & DBPath
[Microsoft][ODBC驱动程序管理器]未发现数据源名称并且未指定默认驱动程序

[dippergao]

这个问题我一时解决不了了……
请大家帮帮忙
谢谢

[xieyj]

试一下:
conndbf.Open "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=" & server.mappath("datacenter/cj.dbf")

[hantor]

conndbf.Open "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=" & server.mappath("datacenter/cj.dbf")
.
.
.
set rs = server.createobject("adodb.recordset")
sql = "SELECT * FROM cj"
rs.execut sql