Does the samples at the following link of help:
Javascript: ADODB & SQL Queries[
^]
A sample from the link:
RETRIEVE DATA FROM SQL DATABASE
Example simple query: query="SELECT x,y FROM blah-blah";
function GetDatabaseData(){
var adOpenDynamic=2;
var adLockOptimistic=3;
sqlArr=new Array();
try{
var rs = new ActiveXObject("ADODB.Recordset");
rs.open(query, conn, adOpenDynamic, adLockOptimistic);
var j=0;var tArr=[];
if(!rs.bof){rs.MoveFirst();}
for(var i=0;i<rs.fields.count;++i){tarr[i]> sqlArr[j]=tArr;j++;
if(!rs.eof){rs.MoveNext();}
while(!rs.eof){
tArr=[];
for(var i=0;i<rs.fields.count;++i){>
tArr[i]=rs.fields(i).value;
if(tArr[i]!=tArr[i]+''){tArr[i]='<object>';}
if(tArr[i]=='null'){tArr[i]='-';}
}
sqlArr[j]=tArr;j++;
rs.MoveNext();
}
rs.close();
}
catch(err01){
conn.close();
conn=null;
Some error handling...
}
}