Dim ConnectString As String '定义连接字符串
Dim Sql As String '定义查询语句
'Set the connect string to use pubs on your SQL server.
ConnectString = _
"Driver={SQL SERVER};Server=<yourserver>;Database=pubs;UID=sa;pwd=;"
Sql = "SELECT pr_info FROM pub_info;"
Set cn = New ADODB.Connection '新建连接对象
cn.ConnectionString = ConnectString
cn.Open '打开连接
Set rsset = New ADODB.Recordset '新建ADODB结果集
rsset.Open Sql, cn, adOpenKeyset, adLockOptimistic, adCmdText 'open参数
rsset.MoveFirst '游标置首