title: How do I associate Parameters to Command objects in ADO with VBScript?
body: <p>I have been working an ADO VBScript that needs to accept parameters and incorporate those parameters in the Query string that gets passed the the database. I keep getting errors when the Record Set Object attempts to open. If I pass a query without parameters, the recordset opens and I can work with the data. When I run the script through a debugger, the command object does not show a value for the parameter object. It seems to me that I am missing something that associates the Command object and Parameter object, but I do not know what. Here is a bit of the VBScript Code: </p>
  
  <pre><code>...
  'Open Text file to collect SQL query string'
  Set fso = CreateObject("Scripting.FileSystemObject")
  fileName = "C:\SQLFUN\Limits_ADO.sql"
  Set tso = fso.OpenTextFile(fileName, FORREADING)
  
  SQL = tso.ReadAll
  
  'Create ADO instance'
   connString = "DRIVER={SQL Server};SERVER=myserver;UID=MyName;PWD=notapassword;   Database=favoriteDB"
   Set connection = CreateObject("ADODB.Connection")
   Set cmd = CreateObject("ADODB.Command")
  
    connection.Open connString
    cmd.ActiveConnection = connection
    cmd.CommandText = SQL
    cmd.CommandType = adCmdText
  
    Set paramTotals = cmd.CreateParameter
    With paramTotals
         .value = "tot%"
         .Name = "Param1"
    End With
  
    'The error occurs on the next line'
    Set recordset = cmd.Execute
  
    If recordset.EOF then
        WScript.Echo "No Data Returned"
    Else
        Do Until recordset.EOF
              WScript.Echo recordset.Fields.Item(0) ' &amp; vbTab &amp; recordset.Fields.Item(1)
              recordset.MoveNext
        Loop
    End If
  </code></pre>
  
  <p>The SQL string that I use is fairly standard except I want to pass a parameter to it. It is something like this:</p>
  
  <pre><code>SELECT column1
  FROM table1
  WHERE column1 IS LIKE ?
  </code></pre>
  
  <p>I understand that ADO should replace the "?" with the parameter value I assign in the script. The problem I am seeing is that the Parameter object shows the correct value, but the command object's parameter field is null according to my debugger. </p>