Dim conn As ADODB.Connection '定义ADO连接对象 Dim rs As ADODB.Recordset '定义ADO记录集对象 Function GetConnection(servername As String, dbname As String, username As String, userpwd As String) Dim connstr As String Set conn = CreateObject("ADODB.Connection") '创建ADO连接对象 'Set rs = CreateObject("ADODB.Recordset") conn.CommandTimeout = 15 '设置超时时间 'connstr = "DRIVER={MySql ODBC 5.1 Driver};SERVER=" & servername & ";Database=" & dbname & ";Uid=" & username & ";Pwd=" & userpwd & ";Stmt=set names GBK" connstr = "DRIVER={MySql ODBC 5.1 Driver};SERVER=127.0.0.1;Database=test;Uid=root;Pwd=123456;Stmt=set names utf-8" conn.ConnectionString = connstr conn.Open 'Dim strsql As String 'strsql = "select count(*) from tbl_user" 'Set rs = conn.Execute(strsql) 'Dim num As String 'num = rs.Fields.Item(0).Value 'MsgBox num End Function
|