Recordset Blues

Results 1 to 2 of 2

Thread: Recordset Blues

  1. #1
    Join Date
    Dec 1969
    Posts
    199

    Default Recordset Blues

    I am using a record set with an active connection to furnish a query result to an ASP page. I am wondering why i get an "Object doesn&#039t support this property or method: &#039open&#039 " when i try to do this:<BR><BR><BR><BR><BR>&#060;%<BR><BR>dim storeCONN, DSN, sql_query, objRS<BR>DSN = "FILEDSN=d:Inetpubwwwrootstoredsnstore.dsn"<BR>SQL _query = "SELECT * FROM product WHERE category LIKE &#039%" & search & "%&#039"<BR><BR><BR>objRS = Server.Createobject ("ADODB.Recordset")<BR>objRS.open sql_query, DSN, 3<BR><BR>storeCONN = objRS.ActiveConnection<BR><BR>%&#062;<BR><BR>I&#03 9d appreciate any help, thanks. <BR><BR>jack.mcclure@eae.siemens.com<BR><BR>

  2. #2
    Nathen Grass Guest

    Default RE: Recordset Blues

    You forgot the Set statement when you create your recordset Object.<BR><BR>set objRS = Server.Createobject("ADODB.Recordset")<BR>

Posting Permissions

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