Ask a questionAsk a question
 

QuestionAdodb.command fails

  • Wednesday, September 30, 2009 2:51 PMRB Dev Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    Using visual studio 2008, I have my default.aspx calling a jscript file which can run adodb.recordset but not adodb.command.
    Error message: microsoft jscript runtime error automation server can't create object scripting.filesystemobject
    when line code is reached var cmd = new ActiveXObject("ADODB.Command");    see code below:


    function

     

    ConnectDatabase(){ //Database Connection

    var

     

    objdb=new ActiveXObject("ADODB.Connection");

    var

     

    cs="Provider=SQLOLEDB;Data Source=HQDW1;Initial Catalog=WorkflowData;User ID=Wkflow;Password=mhm4reports";

    objdb.Mode = 3;

    objdb.Open(cs);

    return

     

    (objdb);

    }

    function

     

    TestConn(){

    var

     

    dbConnection;

    dbConnection=ConnectDatabase();

    var

     

    cmd = new ActiveXObject("ADODB.Command");

     

     

    cmd.ActiveConnection = dbConnection;

    cmd.CommandText =

    "dbo.test";

    cmd.CommandType = adCmdStoredProc;

    params.Append (cmd.CreateParameter(

    "@col2", adVarChar, adParamInput, 50));

    params(

    "@col2") = "rock";

    cmd.Execute;

     

    }