Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=hospital;Data Source=."
con.Open
Dim cmd As ADODB.Command
Dim paras As ADODB.Parameter
Set cmd.ActiveConnection = con '它这里报错-对象变量未设置或with未设置
cmd.CommandText = "Scase"
cmd.CommandType = adCmdStoredProc
Set paras = cmd.CreateParameter("string1", adChar, adParamInput)
cmd.Parameters.Append paras
cmd("string1") = "1"
cmd.Execute
Set con = New ADODB.Connection
con.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=hospital;Data Source=."
con.Open
Dim cmd As ADODB.Command
Dim paras As ADODB.Parameter
Set cmd.ActiveConnection = con '它这里报错-对象变量未设置或with未设置
cmd.CommandText = "Scase"
cmd.CommandType = adCmdStoredProc
Set paras = cmd.CreateParameter("string1", adChar, adParamInput)
cmd.Parameters.Append paras
cmd("string1") = "1"
cmd.Execute
Set con = New ADODB.Connection
con.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=hospital;Data Source=." '引用那个数据库?
con.Open
Dim cmd As ADODB.Command
Set cmd = New Command '在这增加这条
Dim paras As ADODB.Parameter
Set cmd.ActiveConnection = con '它这里报错-对象变量未设置或with未设置
cmd.CommandText = "Scase"
cmd.CommandType = adCmdStoredProc
Set paras = cmd.CreateParameter("string1", adChar, adParamInput)
cmd.Parameters.Append paras
cmd("string1") = "1"
cmd.Execute
是将con实例化,其实Command对象和它一样的,也要实例化方可使用。最后提醒你一句,有开就要有关,用完了要将对象Set 对象名 = Nothing 哦
别让你的程序把系统内存吃个精光才好啊