ADO access using JavaScript

[jerjim]

Can anyone point me to a website which gives examples of active server pages and ADO using JavaScript?

Thanks in advance.

 

[Jaydakissx22]

con = new ActiveXObject("adodb.connection"
rst = new ActiveXObject("adodb.recordset"

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\mp3 data\\mp3database.mdb;";
strSql = "SELECT * FROM mp3dataTables"

con.Open(strConn);

rst.ActiveConnection = con;
rst.CursorType = 3;
rst.LockType = 3;
rst.Source = strSql;
rst.Open;
rst.MoveFirst;



//alert("recordset opened"
//alert("Records in table : " + rst.recordCount);
for(i=0; i<rst.recordCount; i++) {

oNewOption = new Option();
oNewOption.text = rst(&quot;names&quot;
oNewOption.value = rst(&quot;folders&quot;
document.myform.searchFolder.add(oNewOption, 1);

rst.MoveNext;

thats for local db access

try msdn.