不是高手莫进来!:)
在一个DBF文件(ck.dbf)中存在date字段(日期型)
但打开存在错误:
Dim cnnDbf As New ADODB.Connection
Dim rstdbf As New ADODB.Recordset
Dim strcnn As String
strcnn = "DSN=Visual FoxPro Database;UID=;PWD=;SourceDB=C:\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;" 'strCon & DBFpath & strCon1 '"DSN=Visual FoxPro Database;UID=;PWD=;SourceDB=" & DBFpath & ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
cnnDbf.Open strcnn
strsql = "select * from ck where [date]>#2002-01-01#"
rstdbf.Open strsql, cnnDbf, adOpenKeyset, adLockReadOnly
总在最后一句(rstdbf.open)提示错误: odbc驱动程序不支持所需的属性
但是在VisData中运行很好,我想是不是后面的条件有问题,去掉后正常,难道ado不能设置时间(不可能吧),请高手指点!!!