//连接SQL 复制代码 代码如下: <BR>var conn = new ActiveXObject("ADODB.Connection"); <BR>conn.Open("Provider=SQLOLEDB.1; Data Source=tgf; User ID=sa; " <BR>+"Password=sasa; Initial Catalog=MyBulletin"); <BR>var rs = new ActiveXObject("ADODB.Recordset"); <BR>var sql="select id,name from Category"; <BR>rs.open(sql, conn); <BR>alert(rs(0));//取出第一个来 <BR>rs.close(); <BR>rs = null; <BR>conn.close(); <BR>conn = null; <BR> //连接ACCESS 复制代码 代码如下: <BR>function conn(){ <BR>var db_bbs <BR>db_bbs="dd.mdb"//定义数据库 <BR>var conn = new ActiveXObject("ADODB.Connection"); <BR>conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+db_bbs+""); <BR>var rs = new ActiveXObject("ADODB.Recordset"); <BR>var sql="select name from authors"; //数据库中有authors表，name字段 <BR>rs.open(sql,conn); <BR>alert(rs(0))//取出第一个来 <BR>conn.close(); <BR>conn = null; <BR>} <BR>
