Object doesn't support named arguments: 'RS.ActiveConnection'

Posted on 2005-05-07
Last Modified: 2010-05-18
I have a page called "retrieve.asp" that allows the user to select an item to update. That page then sends the user to a page called updateProducts.asp. When the updateProducts.asp page loads I get this error:

Microsoft VBScript runtime error '800a01be'

Object doesn't support named arguments: 'RS.ActiveConnection'

/ASP/updateProducts.asp, line 11

Here is the start of code on my page. Can someone tell me what I'm doing wrong?

'Get the Product ID
productID = Request("pid")

'Open the Database connection
Set Con = Server.CreateObject("ADODB.Connection")
Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/ASP/storeDB.mdb")

'Open the Recordset
Set RS = Server.CreateObject("ADODB.Connection")
RS.ActiveConnection = Con
RS.CursorType = 3
RS.Open "SELECT * FROM Products WHER product_id = " & productID
      productName = RS("product_name")
      productPrice = RS("prodcut_price")
      productPicture = RS("product_picture")
      productCategory = RS("product_category")
      productBriefDesc = RS("product_briefDesc")
      productFullDesc = RS("product_fullDesc")
      productStatus = RS("product_status")

'Close the Recordset

FUNCTION SELECTED(firstVal, secondVal)
      If cSTR(firstVal) = cSTR(secondVal) THEN
            SELECTED = " SELECTED "
      End If
End Function

Any help would be much appreciated.
Question by:Tritorian
    LVL 13

    Accepted Solution

    Set RS = Server.CreateObject("ADODB.Connection") should be Set RS = Server.CreateObject("ADODB.Recordset")

    Author Comment

    @&^*&! lol... I hate that I missed that. Thanks so much for your help!
    LVL 13

    Expert Comment

    no problem,  be more careful next time :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
    Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now