.absolutepage property of Recordset

[jimny]

In an ASP page I am trying to use rs.absolutepage but continually get

ADODB.Recordset error '800a0cb3'

Object or provider is not capable of performing requested operation.

/classified search/basicCS.asp, line 90


I installed the latest sevice pak for JET(service pack 6.0) on the server and change my connection provider to 'SQLoEDB' and still get the same error. What should the provider or connection string be formatted as to use this property?

Iam using:

Set conn = Server.CreateObject("ADODB.Connection&quot
conn.Provider = "sqloledb"
conn.Properties("DataSource&quot.Value = servername
conn.Properties("Initial Catalog&quot.Value = Databasename
conn.Properties("User ID&quot.Value = "sa"
conn.Properties("Password&quot.Value = ""
conn.Open

Any pointers R much appreciated.

 

[onpnt]

did you set the cursor and lock type to adOpenKeyset, adLockReadOnly _________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]

 

[jimny]

Thanks onpnt, but I did set the cursor And locktype:

rsSearch.Open strSQL, conn, adOpenKeyset, adLockReadOnly


I wish it were that easy. Do you know of anything else that might affect it? I got the service pack hint from MSDN, but it didn't do boo.

 

[onpnt]

I found a refernce to someone else having this problem and changing to adUseClient fixed their problem. try it out.

http://www.idevresource.com/forums/forum_view_thread.asp?ThreadID=263&MessageId=144

also in regards to this

http://beta.experts-exchange.com/Web/Web_Languages/ASP/Q_10838341.html

_________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]

 

[onpnt]

and more configurations

http://www.stardeveloper.com/articles/display.html?article=2000071001&page=1

_________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]

 

[jimny]

thanks onpnt,

this link:

http://beta.experts-exchange.com/Web/Web_Languages/ASP/Q_10838341.html

did the trick!