Constant Value Description adUseClient 3 Use client-side cursor supplied by the local cursor library adUseClientBatch 3 Obsolete, same as adUseClient adUseNone 1 Obsolete, no cursor service adUseServer 2 Default, use the cursor supplied by provider or database Code (VBScript): Set objRecordset = Server.CreateObject("ADODB.Recordset") Set objRecordset.ActiveConnection = strConnection objRecordset.CursorLocation = adUseClient objRecordset.CursorType = adOpenDynamic
rs.open "execute 存储过程名字", cn
这样就可以了.楼主试试看吧.
Constant Value Description
adUseClient 3 Use client-side cursor supplied by the local cursor library
adUseClientBatch 3 Obsolete, same as adUseClient
adUseNone 1 Obsolete, no cursor service
adUseServer 2 Default, use the cursor supplied by provider or database
Code (VBScript):
Set objRecordset = Server.CreateObject("ADODB.Recordset")
Set objRecordset.ActiveConnection = strConnection
objRecordset.CursorLocation = adUseClient
objRecordset.CursorType = adOpenDynamic