VB读写SQL（一）——模块篇

'数据库
Public cn As ADODB.Connection
Public rs As ADODB.Recordset
Public addFlag As Boolean   '声明部分

Public Function openCn(ByVal CIp As String, ByVal DBName As String) As Boolean    '连接模块 填写数据库等信息
    Dim mag As String
    On Error GoTo strerrmag
    Set cn = New ADODB.Connection
    cn.ConnectionTimeout = 5
    cn.Provider = "sqloledb"
    cn.Properties("Data Source").Value = CIp    '服务器IP
    cn.Properties("Initial Catalog").Value = DBName    '数据库名字
'    cn.Properties("Integrated Security").Value = "SSPI" '登陆类型
    cn.Properties("User ID").Value = "sa"   '用户名
    cn.Properties("password").Value = "123456"   '密码
    'sql = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=;Initial Catalog=pubs;Data