Hi, I'm trying to create a dynamic table populated with employee contact info. I know there must be a lot of canned soluitions, but thought I try it. Unfdortunately I'm getting the error message in my subject line.
************************************************** *********
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.

/HR/EMPLOYEE_DIRECTORY/directory.asp, line 41
************************************************** *********

Here's what's on Line 41:

************************************************** *********
Line 41: <% do until rsEmployees.eof =true %>
************************************************** *********

... and the rest of the code to generate the table follows as such:


<tr>
    <td><%=(rsEmployees.Fields.Item("EmployeesID").Val ue)%></td>
    <td><%=(rsEmployees.Fields.Item("DepartmentName"). Value)%></td>
    <td><%=(rsEmployees.Fields.Item("Last_Name").Value )%></td>
    <td><%=(rsEmployees.Fields.Item("First_Name").Valu e)%></td>

************************************************** *********
... and so on.. until I have this other piece of code:

<%
  rsEmployees.MoveNext
loop
%>
</table>


Any help would greatly reduce my frustration <smile!>
Thanks all,
Nancy

Hey,

What about the code above that line? That is where your problem is going to be. Post that too.

Brian

Hey, thanks for your quick response...
Here's what's before Line 41:

************************************************** **********


<%
Dim rsEmployees
Dim rsEmployees_numRows

Set rsEmployees = Server.CreateObject("ADODB.Recordset")
'rsEmployees.ActiveConnection = MM_employee_directory_STRING
rsEmployees.Source = "SELECT * FROM Employees ORDER BY Last_Name ASC"
rsEmployees.CursorType = 0
rsEmployees.CursorLocation = 2
rsEmployees.LockType = 1
'rsEmployees.Open()
%>
<table border="1" cellpadding="0" cellspacing="4">
  <tr>
    <td>EmployeesID</td>

... and so on...

************************************************** ***************

Nancy

Brian, do you need more info?

Hey,

You have the rsEmployees.Open() method commented out. That needs to be there for you to access the properties.

Brian

Thx, Brian for getting back to me. 'K, I removed the "comment out", so that that line is read, (not sure why I did a stupid thing like that to begin with, but anyway...)

I'm still getting errors ; Here it is:

ADODB.Recordset error '800a0e7d'

The connection cannot be used to perform this operation. It is either closed or invalid in this context.

/HR/EMPLOYEE_DIRECTORY/directory.asp, line 25

Oddly enough, that line is EXACTLY the line we just put back in??

Line 25: rsEmployees.Open()

Thx Brian for all your help. This problem is solved.

Have a great day!