我连接fox数据库用这个连接串cnDBF.Open "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=" & dbpath & ";SourceType=DBF;"
dbpath是指dbf表的路径,
strsql = "CREATE TABLE [ h_rs_t.dbf ] " & _
"(id int(4),dwbm char(9),dwmc char(30),zgbh char(9),xm char(12),xm_pym char(6),xb char(4)," & _
"bmbm char(10),bmmc char(20),cjgzsj date(8),zjdm char(10),zj char(20),zwdm char(10),zw char(20), " & _
"csrq date(8),jszbdm char(10),jszb char(20),sfzp char(4),zcdm char(10),zc char(20),mqzk char(10), " & _
"mz char(20),hyzk char(4),xx char(10),smwjmc char(9),zz char(60),jdnd char(4),ltnd char(4),zxnd char(4), " & _
"zglb char(50),memo char(50))" '创建表
cnDBF.Execute strsql
rsdbf.Open "select * from h_rs_t.dbf ", cnDBF, adOpenDynamic, adLockOptimistic
执行到rsdbf.Open "select * from h_rs_t.dbf ", cnDBF, adOpenDynamic, adLockOptimistic就提示odbc驱动程序不支持所需的属性
dbpath是指dbf表的路径,
strsql = "CREATE TABLE [ h_rs_t.dbf ] " & _
"(id int(4),dwbm char(9),dwmc char(30),zgbh char(9),xm char(12),xm_pym char(6),xb char(4)," & _
"bmbm char(10),bmmc char(20),cjgzsj date(8),zjdm char(10),zj char(20),zwdm char(10),zw char(20), " & _
"csrq date(8),jszbdm char(10),jszb char(20),sfzp char(4),zcdm char(10),zc char(20),mqzk char(10), " & _
"mz char(20),hyzk char(4),xx char(10),smwjmc char(9),zz char(60),jdnd char(4),ltnd char(4),zxnd char(4), " & _
"zglb char(50),memo char(50))" '创建表
cnDBF.Execute strsql
rsdbf.Open "select * from h_rs_t.dbf ", cnDBF, adOpenDynamic, adLockOptimistic
执行到rsdbf.Open "select * from h_rs_t.dbf ", cnDBF, adOpenDynamic, adLockOptimistic就提示odbc驱动程序不支持所需的属性
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货