Services or applications using ActiveX Data Objects (ADO) 2.0 or greater may
intermittently return empty recordsets on queries that should be returning
valid results. At the time the problem occurs, the same queries successfully
return the expected data when run from non-ADO sources, such as from ISQL in
Microsoft SQL Server. This problem predominantly occurs on multi-processor
computers but has also been known to occur on single-processor computers.
As a side effect, the following error may also occur if the application
tries to use the empty recordset:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted; the
operation requested by the application requires a current record.
Microsoft give a solution at the article
http://support.microsoft.com/kb/230101/EN-US/
but I did it all (I have mdac 2.8 installed and the problem still ocurrs).
I have to tell you that this problem doesnt occurs all the time. When my asp
aplication crashes all the recordsets return the messages :
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted; the
operation requested by the application requires a current record.
and
Description : [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was
not declared.
and
Description : ODBC driver does not support the requested properties
this occurs for some minutes and then start woking again. I have to tell you
that the database is complitly functional when this occurs, and if I do the
same sql querys using query analizer, the sql server return valid results.
The way I can get it work again manualy is by pressing the button "unload"
at the IIS in the "home directory" tab. this makes the asp work again.
Note: (the iis is in one server and the sql is in other server)
this is the way I connect to the database:
'-------------------------objeto conexion
Set cn = CreateObject("adodb.connection")
cn.open = conectacadena
'--------------------------------------------
sql="SELECT * FROM dbo.tblOficinas WHERE strNombre='" + nombreoficina + "'"
Set cmd=CreateObject("adodb.command")
cmd.CommandType=1
cmd.CommandText=sq
Set cmd.ActiveConnection = cn
set Recordset = Server.CreateObject("ADODB.Recordset")
Recordset=cmd.Execute()
'-------------------------------------------------------
any suggestions?????????? do I have to install any patch????? do I have to
do something in my iis????
note: this is an aplication on the intranet of the company and has a heavy
transactional job all the day over the database.