Re: random 3021 errors


"MVPinFLA" <MVPinFLA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:79D1EE1B-46C9-4BF4-A978-A5B6FB26C7DE@xxxxxxxxxxxxxxxx
my vb6 application is running on windows server 2003 (mdac 2.8) and is
getting random runtime error 3021 (either BOF or EOF is true, or the
current
record has been deleted. requested operation requires a current record
with
this code.) the database is on a windows 2000 server running mdac 2.7.

this happens randomly on win2003 with mdac 2.8, doesn't occur if
application
is run on win2000 server with mdac 2.7.

i'm thinking mdac is the problem, should i upgrade my db server to mdac
2.8?


Hi,

I think more likely the recordset is empty (the query found no matches) or
you did something to move the cursor to the end (like retrieve RecordCount).
Plus, I don't believe upgrading mdac on the server (w2k machine) will have
any affect on the application running on the client (W2k3 machine).

Another thought is that you experience the error when the database is
remote. However, if there is a timeout you should get a different error
message.

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net


.