Thanks, that helped me too, after reading all tones of other nit-helping
> Neil, you might try using the value 3 instead of the ADO constant. If
> don't have the reference set in your global.asa file ASP will default to
> the value of 0 (or NULL?) which is incompatible.
> So, try this instead
> rsTbl.cursorlocation = 3
> rsTbl.Open "tblBooks", cnDb, 0, 1, 2
> I was able to run your code to run on my machine so it should work for
> -----Original Message-----
> From: Neil Price [mailto:neil_price@s...]
> Sent: Friday, March 10, 2000 7:14 AM
> To: Code Clinic
> Subject: [proasp_codeclinic] ADODB.Recordset error '800a0bb9'
> Dear All,
> The following code generates the ADODB.Recordset error '800a0bb9' on
> 10, which is where I set the cursorlocation. I have checked the
> support site and they say that this is caused by applying a filter,
> doesn't seem to be the case.
> Any help would be very much appreciated.
> Neil Price
> -Dim cnDb
> -Dim rsTbl
> -Dim strCon
> -Dim strSel
> -Set cnDb = Server.CreateObject("ADODB.Connection")
> -Set rsTbl = Server.CreateObject("ADODB.Recordset")
> -strCon = "Provider=SQLOLEDB;Data
> -cnDB.Open strCon
> -rsTbl.PageSize = 5
> -rsTbl.CursorLocation = adUseClient
> -rsTbl.Open tblBooks, cnDb, adOpenForwardOnly, adLockReadOnly, adCmdTable
> You are currently subscribed to proasp_codeclinic as: Davidh@D...
> To unsubscribe send a blank email to