嗨必胜博客

新建一个工程,在菜单-工程-引用里选"Microsoft ActiveX Data Objects 2.0 Library",代码里需要有dim conn As New ADODB.Connection '定义ADO数据库对象conn.ConnectionString = "driver={SQL Server};" & _ "server=" & ServerName & ";uid=" & UserName & ";pwd=" & Password & ";database=" & DatabaseName & "" '连接数据串conn.open

More...