ado Error Code 3219

[Roger Stenson]

Hi
I am writing a Class Module in VB6.
With each of the main methods I begin by opening the required recordsets,
and as I leave the method I close them, with a statement as follows.
"If rsOutput.State = adStateOpen Then rsOutput.Close"
All of them close successfully except the one whose closure statement is
identified above. The closure generates error code 3219 which indicates
that closure is illegal in the circumstances. The particular recordset has a
State = 1 and a Status = 0 when the above instruction is executed. All of
the code in the method seems to have executed correctly and the Output file
contains the expected records

I have never encountered this message bore and searching the through the
vb6 documentation and an Ado Reference Manual gives me no help. I would be
grateful if someone could help me discover the potential reasons that will
render a recordset closure illegal.
With thanks in anticipation
Roger Stenson

 

[Douglas J. Steele]

After years of trying to figure out what causes what error in my clean-up
routines, I've got in the habit of setting On Error Resume Next in my
clean-up section.

 

[Brendan Reynolds]

I have some 'issues' with ADO help in Access (i.e., the damn thing doesn't
work). I've been able to determine that a State of 1 is adStateOpen, but
what does a Status of 0 indicate?

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Douglas J. Steele]

It's supposed to indicate that the record was successfully updated.

http://msdn.microsoft.com/library/en-us/ado270/htm/mdcstrecordstatusenum.asp

 

[Brendan Reynolds]

Thanks Doug. In that case, I'm afraid there doesn't seem to be anything in
the information available that would indicate the reason for the error.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.