Win2003 ASP连接dbf文件出错
863 2007-04-18 06:34:01 数据库MyData.dbf
<%
' 建立Connection 对象
Set conn = Server.CreateObject("ADODB.Connection")
Driver = "Driver={Microsoft Visual FoxPro Driver};"
SourceType = "SourceType=DBF;"
DBPath = "SourceDB=" & Server.MapPath( "MyData" )
' 调用Open 方法连接数据库
conn.Open Driver & SourceType & DBPath
Set rs = Server.CreateObject("ADODB.Recordset")
' 打开数据源,参数二为Connection对象
rs.Open "Select * From Mydata", conn, 2, 2 //这一行出错:
//Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
//ODBC 驱动程序不支持所需的属性。
%>
请指教!