I had already viewed those tutorials and found them not to be of much help. However here is the code i currently have written but it gives me and error.<BR><BR><option><BR><%<BR>dim rs<BR><BR>rs.Open "tblHRPeople"<BR><BR>While Not rs.EOF<BR>Response.Write rs("person")<BR>rs.MoveNext<BR>Wend<BR>rs.Close<BR >Set rs = Nothing %><BR></option><BR><BR>The error is 800a01a8 "object Required" not sure what that means and not sure whats wrong with the code.
Tried that but it gives me the error: <BR>Microsoft OLE DB Provider for ODBC Drivers error <BR>'80004005'[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified<BR><BR>...What do you make of that<BR>
Patrick<BR><BR>One of the most common types of problems occurs when ASP attempts to access resources located on remote machines. An example of this is using ADO to access either SQL Server on a remote machine or an Access .mdb file located on another Windows NT machine. The problems stem from the fact that ASP is operating in the context of the IUSR_MACHINE account. <BR><BR>On servers that are not primary or backup domain controllers, the IUSR_MACHINE account is a local account. Since this local account is not recognized on the remote machine, access is denied to the database. <BR><BR>You can either Change the Anonymous Logon account on the IIS server from IUSR_MACHINE to a domain account that is recognized by both machines and has sufficient permissions to the resource. In addition, be sure that this account has the log on locally user right on the IIS machine. Recall that the Anonymous Logon account is configured through Internet Service Manager. <BR><BR><BR>If you later decide to change back to the IUSR_MACHINE account, be sure that the password provided in Internet Service Manager matches the password provided for this account in the User Manager tool. If the passwords do not match, you will encounter Access Denied errors. <BR><BR>