title: what does the line var connection = new ActiveXObject("ADODB.Connection"); mean and why doesn't it work?
body: <p>I have found a code in net, and there is a code line there, which I don't undersand it meaning and what does it do. Moreover the line doesn't work. Can anyone help?</p>
  
  <p>the code-</p>
  
  <pre><code>    var connection = new ActiveXObject("ADODB.Connection"); /*the line*/
  var connectionstring = "Data Source=srvp7rnd-herm;Initial Catalog=hermes;User ID=hermes;Password=hermes;Provider=SQLOLEDB";
  connection.Open(connectionstring);
  
  /* JavaScript obect to access a SQL query's results */
  var rs = new ActiveXObject("ADODB.Recordset");
  
  /* Getting the current MAX(id) from the database */
  rs.Open("SELECT MAX(id) FROM Screen_Template", connection);
  rs.MoveFirst;
  var maxID = rs.Fields.Item(0);
  maxID = maxID + 1;
  
  /* TODO: Get the last UID */
  var sql = "INSERT INTO Screen_Template(template_name, OpCo, env, template_xml, language, id, title, role, UID) VALUES (" + templateName + "," + opco + "," + env + "," + "&lt;hello&gt;hello&lt;/hello&gt;" + ",eng," + maxID + ",Hermes SMS message composer," + "manag, 10)";
  alert(sql);
  rs.Open(sql, connection);
  
  /* Closing the connections */
  rs.close;
  connection.close;
  </code></pre>