如何用JS连接ADO数据库

Question

var cn = Server.CreateObject("adodb.connection")
cn.open("connstring")

Answer 1

楼上的是asp的吧
JS好像是用new 不太清楚

Answer 2

<script language="javascript" runat="server">
  //用 JavaScript 写服务器端连接数据库的代码示例
  var conn = new ActiveXObject("ADODB.Connection");
  conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; "
    +"Password=password; Initial Catalog=meizz");  var rs = new ActiveXObject("ADODB.Recordset");
  var sql="select user_kind from tbRightSet where user_id='"+ Account +"'";  rs.open(sql, conn);
  if (!rs.EOF)
  {
    sysUserKind = (rs("user_kind")+"").replace(/^\s+|\s+$/, "");
  }
  rs.close(); rs = null; conn.close(); conn = null;
</script>

Answer 3

strDBName = "/xtree/database/tree.mdb";
strPassword = "admin";
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.Mappath(strDBName)+";Jet OLEDB:Database Password="+strPassword
Application("strConn")=strConn;