ADODB.Recordset error '800a0e78'

I get the error "ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

/athleteprofile.asp, line 44"


It occurs during the processing of this code

<%
Aname = Trim(Request.Form("Aname"))
Password = Trim(Request.Form("Password"))
%>

<%
Dim nconnect, nrecord, query
Set nconnect = Server.CreateObject("ADODB.Connection")
Set nrecord = Server.CreateObject("ADODB.Recordset")
query = "Select Name, Password From qrynamepwfull" _
& "Where Name = '"&Aname&"' And Password = '"&Password&"'"
nconnect.Open "athlpacts_153966"
Do While Not nrecord.EOF - - - this is line 44 - - -
%>


Can you tell me what is causing this? The object is not closed.

Thanks!

If you are sure the object is not closed (you can check with "connection.state" I believe), then the error could come from running a statement or stored query that returns an empty recordset. http://support.microsoft.com/defaul...kb;en-us;301437
Always look up these error messages at microsoft.com, they usually have explainations and workarounds.
HTH