Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BionicHartman

    I get operation is not allowed when the object is open error

    Thanks PH. I made the change as described but I am still getting the same error. This is only my second VBScript and I the query portion I wrote in Query Analyzer and pasted it into here. So I will be more than happy to fix the errors, is it just in the query portion that you see issues or the...
  2. BionicHartman

    I get operation is not allowed when the object is open error

    When I execute the script it tells me: "Operation is not allowed when the object is open. Line 32 "myMainConnection.open" I tried looking out in the FAQs and couldn't find anything that addressed something similar. I tried adding a .Close at the end but then it gives me the same error but...
  3. BionicHartman

    Getting "Object Required" when running VBScript

    Thanks, that helped a lot and took care of that error message. Now I am getting an error "Object Variable not set Line (6): "objRecordSet.Source = "DECLARE @CURRENT_DATE DATETIME" &_". I appreciate the assistance, Micah
  4. BionicHartman

    Getting "Object Required" when running VBScript

    I have a script that is VBScript and not ASP, that when I kick it off I keep getting the error message "Line (2): "Set myMainConnection = CreateSqlConnection()". I am not sure what it is wanting here, below is the code: Dim myMainConnection Set myMainConnection = CreateSqlConnection()...

Part and Inventory Search

Back
Top