The Requested Properties Cannot Be Supported. Error '80040e21'

Hi,

I get this error "sometimes" on sql server 2000 (

The requested properties cannot be supported. error '80040e21'

when running the code below multiple times.

Any solutions for this ?

thanks in advance



gr.

Peter





Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Mode = 3 '1 = adModeReadOnly
Conn.Open ConnectString
SqlSend= "Select top 30 * from tab1 WITH (UPDLOCK,readpast) where x<>'' and RecordNumber > 6200000 and Status= 2 and processed <> 3 ORDER BY RecordNumber"
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Cursortype=0
rs.Cursorlocation =2
rs.LockType= 3
rs.Open SqlSend, Conn < here it gives the error