'ado
Dim gcn as new adodb.connection strConnect = "Provider=MSDASQL;Driver=Microsoft Visual FoxPro Driver;UID=;PWD=;SourceDB=D:\;" & _
"SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=NO;" '»ò:
strConnect = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;" & _
"sourceDB='" & DBPath gCn.CursorLocation = adUseServer
gCn.CommandTimeout = 0
gCn.ConnectionTimeout = 0
gCn.Open strConnect
Dim gcn as new adodb.connection strConnect = "Provider=MSDASQL;Driver=Microsoft Visual FoxPro Driver;UID=;PWD=;SourceDB=D:\;" & _
"SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=NO;" '»ò:
strConnect = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;" & _
"sourceDB='" & DBPath gCn.CursorLocation = adUseServer
gCn.CommandTimeout = 0
gCn.ConnectionTimeout = 0
gCn.Open strConnect
Run-time error'-2147467259(80004005)':
[Microsoft][ODBC Visual FoxPro Driver]Fox Error 1
这是什么问题?驱动问题?我用VF很正常。
我用下面的语句打开表
Set rs = gcn.Execute("select * from test")
已经可以打开,但是不能修改更新,错误提示是:Run-time error '3251':
当前Recordset不支持更新。这可能是提供者限制的,也可能是选定的锁定类型限制的。 请问是什么原因?该如何打开才能编辑?