ADO With JavaScript

Author: Marcio Coelho

URL: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2804&lngWId=2

/* -------------------------------------------------
   ADO With JavaScript
   --
   Description: I have not found any sample that shows
   database access with javaScript. Well, I created one.
   It is very simple since Javascript has the activeXObject
   that allow us to call an external object in the same
   way that vbscript uses CreateObject.

   By: Marcio Coelho
------------------------------------------------- */

var conn = new ActiveXObject("ADODB.Connection") ;
var connectionstring = "Provider=sqloledb; Data Source=itdev; Initial Catalog=pubs; User ID=sa;Password=yourpassword"

conn.Open(connectionstring)

var rs = new ActiveXObject("ADODB.Recordset")
rs.Open("SELECT gif, description, page, location FROM menu1", conn)

// Be aware that I am selecting from this table, but you need to pick your own table
while(!rs.eof)
{
    alert(rs(0));
    rs.movenext
}

rs.close
conn.close