Connection.Execute 如何在 VBScript 中工作？

问：

如何在 VBScript 中工作？Connection.Execute

Dim Connection
Set Connection = CreateObject("ADODB.Connection")
connection.open(Parameter)

Dim sql
sql = "sql query"

Dim RowsReturn
Err.Clear
Connection.CommandTimeout = 30  
Connection.Execute SQLStatement, RowsReturn, 1

我正在尝试用 JavaScript 重写代码。我在下面错过了什么？

var connection = new ActiveXObject("ADODB.Connection");
var rs = new ActiveXObject("ADODB.Recordset");  
connectionstring = "Connection String "
connection.Open(connectionstring);

var sql = "Sql query"

rs = connection.execute(sql);

我需要帮助来理解这句话。Connection.Execute SQLStatement, RowsReturn, 1