用javascript来访问数据库，可能会在客户端调试中有点用处！

<script language="javascript" type="text/javascript"> //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; " +"Password=cmx; Initial Catalog=pubs"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="select * from authors"; rs.open(sql, conn); shtml = "

"; shtml +="

au_id

au_lname

au_fname

phone

address

city

state

zip

"; while(!rs.EOF) { shtml += "

" + rs("au_id") + "

" + rs("au_lname") + "

" + rs("au_fname") + "

" + rs("phone") + "

" + rs("address") + "

" + rs("city") + "

" + rs("state") + "

" + rs("zip") + "

"; rs.moveNext; } shtml += " "; document.write(shtml); rs.close(); rs = null; conn.close(); conn = null; </script>     把  <script language="javascript" type="text/javascript"> //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; " +"Password=cmx; Initial Catalog=pubs"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="select * from authors"; rs.open(sql, conn); shtml = " "; shtml +="

au_id

au_lname

au_fname

phone

address

city

state

zip

"; while(!rs.EOF) { shtml += "

" + rs("au_id") + "

" + rs("au_lname") + "

" + rs("au_fname") + "

" + rs("phone") + "

" + rs("address") + "

" + rs("city") + "

" + rs("state") + "

" + rs("zip") + "

"; rs.moveNext; } shtml += " "; document.write(shtml); rs.close(); rs = null; conn.close(); conn = null; </script>  ADODB.Connection作为一个 ActiveX控件来使用，这样即使不会javascript的人，也很容易写出下面的代码

<script language="javascript">
  //用 JavaScript 写服务器端连接数据库的代码示例
  var conn = new ActiveXObject("ADODB.Connection");
  conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; Password=; Initial Catalog=pubs");
  var rs = new ActiveXObject("ADODB.Recordset");
  var sql="select * from authors";
  rs.open(sql, conn);
  shtml = "":
  while(!rs.EOF)
  {
      shtml += rs("au_id") + "<br>" + rs("au_lname") + "<br>" + rs("au_fname") ;
      rs.moveNext;
  } 
  document.write(shtml);
  rs.close(); 
  rs = null; 
  conn.close(); 
  conn = null;
</script>