paging problem

From: Savas Ates (savas_at_indexinteractive.com)
Date: 08/28/04 

Date: Sat, 28 Aug 2004 15:09:22 +0300

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

Relevant Pages

  • paging problem
    ... provider, or of the selected locktype. ... ;password=;Data Source=localhost" (it is oledb) ...
    (microsoft.public.inetserver.asp.general)
  • Re: Invoking ADO.NET Connection String dialog?
    ... newsgroup to check for Sql Server in the return Connection String, ... > The data link dialog is an OLEDB feature. ... If you only use the OleDb managed provider in ado.net, ... > Program Manager - ADO.NET Team ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Invoking ADO.NET Connection String dialog?
    ... It just passes that PROMPT option down in the stack so oledb will show the ... > to retrieve an OLEDB Connection string. ... If you only use the OleDb managed provider in ado.net, ... >> Program Manager - ADO.NET Team ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: nVarchar limitations using OLEDB provider
    ... but not nvarcharor greater using a clientside cursor. ... is IMHO what OLEDB is designed for: ... Unless of course this OLEDB provider is not supported at all..... ... The issue may actually lie on the client code and not on the ...
    (microsoft.public.sqlserver.ce)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... ODBC was superseded thirteen years ago by OleDb: ... In this particular case, my program will conect to an Oracle database, but ... There does not seem to be a .NET provider for MS Access, ...
    (microsoft.public.dotnet.framework.adonet)