object is closed????????

Results 1 to 2 of 2

Thread: object is closed????????

  1. #1
    Join Date
    Dec 1969

    Default object is closed????????

    here is my code. I am getting an error telling me that Operation is not allowed when the object is closed.<BR>I have used this same code before and it worked. What am i missing causing it to not open?<BR>&#060;%<BR>&#039; declare variables<BR>Dim dbObj, rs, sql, project, id_no, loopcounter<BR><BR>id_no = request("id_no")<BR>project = request("project_choice")<BR>project = trim(project)<BR><BR>&#039; creating connection object<BR>Set dbObj = Server.CreateObject("ADODB.Connection")<BR>&#039; opening dsn connection<BR>dbObj.Open "driver={SQL Server};" & _<BR> "server=scsi-empower;uid=sa;database=aa_data"<BR><BR>Set rs = Server.CreateObject ("ADODB.Recordset")<BR>sql = "select Auditionor.id_no, projects.Auditionor_Id, projects.Project_Id, projects.Project_Label, projects.Num_Roles, Roles.Auditionor_ID, Roles.Project_ID, Roles.Role_Number, Roles.Role_Label FROM Auditionor, projects, Roles where projects.Project_Id = &#039;" & project & "&#039; and Auditionor.id_no = projects.Auditionor_Id and Roles.Auditionor_ID = projects.Auditionor_Id order by Roles.Role_Number"<BR><BR>rs.Open sql, dbObj<BR>loopCounter = 1<BR>%&#062;

  2. #2
    Join Date
    Dec 1969

    Default RE: object is closed????????

    looks OK to me, where&#039;s the error, exactly?<BR><BR>j

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts