Question

VB6.0中，Microsoft ODBC 驱动程序管理器未发现数据源名称且并未指定默认驱动程序，要怎么修改

Private Sub form_load()Dim cn As New ADODB.ConnectionSet cn = New ADODB.Connectioncn.connectionstring = "F:\User data management system\Data\User data management database.mdb;Persist Security Info=False"cn.OpenDim rs As New ADODB.Recordsetrs.Open "Select * from User where UerId= userID=(select userID from test where userID=" & Form1.Text1.Text & ")"rs.Open sql, cn, adOpenKeyset, adLockPessimisticEnd SubPrivate Sub Text1_load()Set Text1.DataSource = rsText1.DataField = rs.Fields("用户编号")End SubPrivate Sub Text2_load()Set Text1.DataSource = rsText1.DataField = rs.Fields("用户姓名")End SubPrivate Sub Text3_load()Set Text1.DataSource = rsText1.DataField = rs.Fields("身份证号")End SubPrivate Sub Text4_load()Set Text1.DataSource = rsText1.DataField = rs.Fields("其他信息")End Sub

这个要怎么修改？

Answer 1

cn.connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=F:\User data management system\Data\User data management database.mdb;Persist Security Info=False"

Answer 2

您好，对于您这样的情况建议您下载最新版本的驱动软件，更新到最新版本的驱动。

Answer 3

您好，类似于这样的驱动程序建议您在官网更新到最新版本试一下，一般是比较有效果的。