准备工作:
1.VB新增引用dll——Microsoft Activex Data Object 2.8 Library
2.创建.udl文件,设定数据库链接,获取ConnectionString
ADO应用示例:
Private Sub Command1_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As String
‘打开数据库
cn.ConnectionString = “Prov ...