Dim conn1 As ADODB.Connection
Dim Rs As ADODB.Recordset
Dim SQLServerConnect As String
SQLServerConnect = "Driver={SQL Server};Server=TCL;Database=pubs;" & _
"UID=sa;PWD=;" '连接字符串
Set conn1 = New ADODB.Connection
conn1.ConnectionString = SQLServerConnect
conn1.Open
Set Rs = conn1.Execute("select getdate()")
Debug.Print Rs(0)
Set Rs = Nothing
Dim Rs As ADODB.Recordset
Dim SQLServerConnect As String
SQLServerConnect = "Driver={SQL Server};Server=TCL;Database=pubs;" & _
"UID=sa;PWD=;" '连接字符串
Set conn1 = New ADODB.Connection
conn1.ConnectionString = SQLServerConnect
conn1.Open
Set Rs = conn1.Execute("select getdate()")
Debug.Print Rs(0)
Set Rs = Nothing
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货