ado连接字符串问题????????????????????????????

[autocar]

ado连接字符串问题????????????????????????????


在连接foxfro 数据库时出错

连接字符串如下:

Driver={Microsoft Visual Foxpro Driver }; sourcetype=dbc ; sourcedb=e:\foxprodata\data1.dbc

错误提示:
data source name not found and no default driver specified

[饮水需思源]

Dim Cn As New ADODB.Connection

Cn.ConnectionString = "provider=msdasql;DRIVER=Microsoft Visual FoxPro Driver;UID=;Deleted=yes;Null=no;Collate=Machine;BackgroundFetch=no;Exclusive=No;SourceType=DBF;SourceDB=e:\foxprodata;"

Cn.Open