title: Javascript ADO recordset open method not working
body: <p>I have the following code in an html page in a Javascript tag:</p>
  
  <pre><code>        var adOpenDynamic = 2
  var adLockOptimistic = 3
  var conn_str = 'Provider=Microsoft.Jet.OLEDB.4.0; Data Source=G:/path_to_myDB.mdb'
          var conn = new ActiveXObject("ADODB.Connection")
  conn.open(conn_str)
  </code></pre>
  
  <p>and this is a the beginning of a function that is called from the onload event of the html  :</p>
  
  <pre><code>  var PassNbrAppel = new Array();
    var i=1
    var rsPass = new ActiveXObject("ADODB.Recordset")
  
    SQLpass = 'SELECT Avis.[Numéro Passerelle], Count(Avis.[Numéro Passerelle]) AS [CompteDeNuméro Passerelle] FROM Avis  WHERE (((Avis.[Date Appel])&gt;#10/19/2011# And (Avis.[Date Appel])&lt;#11/07/2011#) AND (Avis.[Numéro Passerelle] IS NOT NULL)) GROUP BY Avis.[Numéro Passerelle] ORDER BY Val(Avis.[Numéro Passerelle]);'
  
    rsPass.open(SQLpass, conn, adOpenDynamic, adLockOptimistic)
  
    rs2arr(rsPass,arrPass)      
  
    rs.close()
  </code></pre>
  
  <p>I get the following error message (translated from french): "no value given for one or more of the required parameters" and the line number is pointing to       <code>rsPass.open(SQLpass, conn, adOpenDynamic, adLockOptimistic)</code>
  I keep on re-checking to see if there is a mistake in the code but I can't seem to find anything wrong...</p>
  
  <p>I took bits of code from <a href="http://www.kuro5hin.org/story/2005/7/14/13942/7643" rel="nofollow">here</a></p>