lo hago asi
Código PHP:
set rs=Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_sumer_con_STRING
rs.Source = sql
rs.PageSize = numregistresmostrats
rs.CacheSize = numregistresmostrats
rs.CursorType = 3
rs.CursorLocation = 3
rs.LockType = 3
rs.open ()