用OLEDB 方式连接SQL2000,在存储过程中从固定表选出结果集,用OLEDB的RS能返回结果集.同样的连接,
从临时表选出结果集用OLEDB的RS却无法返回结果集.当用ODBC时又可以返回(但公司定死不能用).怎样解? Dim cn5 As New ADODB.Connection
Dim rs_print As New ADODB.Recordset
Dim Cmd_print As New ADODB.Command
dim l as integer With cn5
.ConnectionString = P_Connectionstring
.CommandTimeout = 600
.Open
End With With Cmd_print
.CommandText = "zzz"
.CommandType = adCmdStoredProc
.CommandTimeout = 5000
.ActiveConnection = cn5
Set rs_print = .Execute
End With l = rs_print(0)
错误提示:RS_PRINT 是关闭的,不能操作.
从临时表选出结果集用OLEDB的RS却无法返回结果集.当用ODBC时又可以返回(但公司定死不能用).怎样解? Dim cn5 As New ADODB.Connection
Dim rs_print As New ADODB.Recordset
Dim Cmd_print As New ADODB.Command
dim l as integer With cn5
.ConnectionString = P_Connectionstring
.CommandTimeout = 600
.Open
End With With Cmd_print
.CommandText = "zzz"
.CommandType = adCmdStoredProc
.CommandTimeout = 5000
.ActiveConnection = cn5
Set rs_print = .Execute
End With l = rs_print(0)
错误提示:RS_PRINT 是关闭的,不能操作.
Dim rs_print As New ADODB.Recordset
Dim Cmd_print As New ADODB.Command
With cn5
.ConnectionString = P_Connectionstring
.CommandTimeout = 15
.Open
End With
With Cmd_print
.ActiveConnection = cn5
.CommandType = adCmdStoredProc
.CommandText = "zzz"
Set rs_print = .Execute
End With