paging problem -- sql server programming

Savas Ates
8/28/2004 3:09:22 PM

Current Recordset does not support updating. This may be a limitation of the
provider, or of the selected locktype.

my connection string

Set baglantim=Server.Createobject("ADODB.Connection")
Outpost="PROVIDER=SQLOledb;Initial Catalog=friends;User Id=sa
;password=;Data Source=localhost" (it is oledb)

im using stored procedure to make a user search in asp what is my fault?
error line absolute page...

xx="exec st_usersearch
@email='',@firstname='',@surname='',@citytr='',@usergender='',@onlinestatus=
''"

Sayfalanacak_Kayit=5

If Request.QueryString("Sayfa") = "" Then
Gosterilen_Sayfa = 1
Else
Gosterilen_Sayfa = CInt(Request.QueryString("Sayfa"))
End If

set rs=server.CreateObject("adodb.recordset")

rs.pagesize=Sayfalanacak_Kayit

rs.open xx,baglantim,1,3

If Gosterilen_Sayfa > Toplam_Sayfa Then Gosterilen_Sayfa = Toplam_Sayfa
If Gosterilen_Sayfa < 1 Then Gosterilen_Sayfa = 1

rs.AbsolutePage = Gosterilen_Sayfa

Ilya Margolin
8/31/2004 8:45:22 AM

Savas,

If a recordset source is a stored procedure it cannot be updated because in
general sense there is no direct (parse-able) link between recordset columns
and table columns.

Ilya

[quoted text, click to view]

sql server programming : paging problem