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;
}