注册 登录
编程论坛 VB6论坛

VB连接数据库提示 找不到可安装的ISAM

a62561jp 发布于 2013-07-11 15:48, 856 次点击
代码如下
Private Sub Command1_Click()
Dim sql As String     'SQL语句
Dim connectionstring As String     '连接信息
Dim conn As New Connection     '数据库连接变量
Dim rst As New Recordset     '结果集
connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;dxdata Source=" & App.Path & "\考试.mdb;Persist Security Info=False"

  conn.Open connectionstring
    sql = "select * from 单选题 where 题号  = '" & th & "'"
      rst.Open sql, conn, adOpenKeyset, adLockPessimistic
     Label1 = rst.Fields("题目")
End Sub
2 回复
#2
LK8682013-07-11 21:37
connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\考试.mdb;Persist Security Info=False"

#3
a62561jp2013-07-11 22:26
额。。。粗心了,问题解决了。谢谢啊
1