p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_codeclinic thread: ADODB.Recordset error '800a0bb9'


Message #1 by "Neil Price" <neil_price@s...> on Fri, 10 Mar 2000 15:13:32
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

$subst('Email.Unsub')

  Return to Index