01.<!doctype html>
02.<html>
03.<head>
04.<meta charset="utf-8">
05.<title>Untitled Document</title>
06.
07.<script type="text/javascript">
08.function loadDB() {
09. var connection = new ActiveXObject("ADODB.Connection") ;
10.
11. var connectionstring="Data Source=server name;Initial Catalog=databast name;User ID=user name;Password=password;Provider=SQLOLEDB";
12.
13.connection.Open(connectionstring);
14.var rs = new ActiveXObject("ADODB.Recordset");
15.
16.rs.Open("SELECT * FROM table", connection);
17.rs.MoveFirst
18.while(!rs.eof)
19.{
20. document.write(rs.fields(1));
21. rs.movenext;
22.}
23.
24.rs.close;
25.connection.close;
26. }
27.</script>
28.
29.
30.</head>
31.
32.<body onload="loadDB()">
33.<div id="main"></div>
34.</body>
35.</html>
