p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_codeclinic thread: RE: ADODB.Recordset error '800a0bb9'


Message #1 by "avivit sa" <avivit@m...> on Thu, 14 Nov 2002 11:26:06
Thanks, that helped me too, after reading all tones of other nit-helping 
documentation.

> Neil, you might try using the value 3 instead of the ADO constant.  If 
you
> 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 
you.
> 
> David
> 
> 
> -----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 
line 
> 10, which is where I set the cursorlocation.  I have checked the 
Microsoft 
> support site and they say that this is caused by applying a filter, 
which 
> doesn't seem to be the case.
> 
> Any help would be very much appreciated.
> 
> Regards
> 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 
Source=sbliis;InitialCatalog=abadata;User 
> ID=sa"
> -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
> $subst('Email.Unsub')

  Return to Index