Set Conn = New ADODB.Connection
connstr = "Driver={sql server};server=202.xxx.xxx.xxx;uid=sa;pwd=billing;database=SmartBilling"
'connsql.ConnectionString = strsql
'connsql.ConnectionTimeout = 10 '超时时间
Conn.Open connstr
'If conn.State = adStateOpen Then
Set rs2 = CreateObject("ADODB.Recordset")
sql2 = "select * from admin"
rs2.Open , sql2, Conn, 2, 3 <---这行提示错误实时错误‘-2147352571(80020005)’
If Not rs2.EOF Then
Do While Not rs2.EOF
'Text2.Text = rs2("autonum")
rs2.MoveNext
Loop
End If
connstr = "Driver={sql server};server=202.xxx.xxx.xxx;uid=sa;pwd=billing;database=SmartBilling"
'connsql.ConnectionString = strsql
'connsql.ConnectionTimeout = 10 '超时时间
Conn.Open connstr
'If conn.State = adStateOpen Then
Set rs2 = CreateObject("ADODB.Recordset")
sql2 = "select * from admin"
rs2.Open , sql2, Conn, 2, 3 <---这行提示错误实时错误‘-2147352571(80020005)’
If Not rs2.EOF Then
Do While Not rs2.EOF
'Text2.Text = rs2("autonum")
rs2.MoveNext
Loop
End If
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货