Private Sub lianjieSQL()
On Error Resume Next
'Dim DBconnect As New ADODB.Connection
Dim conn As New ADODB.Connection
' Set conn = New ADODB.Connection
'建立无源数据库连接
conn.ConnectionString = "server=.;integrated security=SSPI;Database=tupian"conn.Open
MsgBox conn.State
End Sub
代码如上,我觉得我的代码写的没问题啊,但是conn.state=0;为啥啊?tupian是我的数据库名称
On Error Resume Next
'Dim DBconnect As New ADODB.Connection
Dim conn As New ADODB.Connection
' Set conn = New ADODB.Connection
'建立无源数据库连接
conn.ConnectionString = "server=.;integrated security=SSPI;Database=tupian"conn.Open
MsgBox conn.State
End Sub
代码如上,我觉得我的代码写的没问题啊,但是conn.state=0;为啥啊?tupian是我的数据库名称
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货