方式1:可以连,但打不开有索引文件的dbf文件
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\10.132.98.113\d\TASV\C01;Extended Properties=dbaSE 5.0;Persist Security Info=False
方式2:不能连,错误是“未发现数据源名称并且未指定默认驱动程序”
Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceType=DBF;DBQ=\\10.132.98.113\d\TASV\C01
方式3:不能连,这是在论坛搜索的,看起来最象,但不会用,id和密码怎么设置?
provider=VFPOLEDB.1;SourceType=DBF;Exclusive=No;data source=\\10.132.98.113\d\TASV\C01;Mode=ReadWrite|Share Deny None;User ID=myUID;Password=password;
请教各位,应该用怎样的连接字符串才可以呢??
------解决方案--------------------------------------------------------
Provider=VFPOLEDB.1;Data Source=\\10.132.98.113\d\TASV\C01;Password= " ";Collating Sequence=MACHINE
------解决方案--------------------------------------------------------
标准连接:
"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=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.168.0.1\zz;Extended Properties=dbaSE 5.0;Persist Security Info=False "
------解决方案--------------------------------------------------------
top