Shoutbox

it seems you're using a microsoft access database... so why not use COM to open it in jscript

an example of opening , fetching some data and closing the database

code:

---

var db = new ActiveXObject('ADODB.Connection');
var dbPath = "C:\\Program Files\\Messenger Plus! Live\\Scripts\\test\\db1.mdb";
db.open("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" + dbPath +";DefaultDir=;UID=;PWD=;");

var results = db.Execute("SELECT * FROM xxx");

var xxx = resultsToArray(results);

for(var i=0;i<xxx.length;i++){
    Debug.Trace("Row: " + i);
    for(x in xxx[i]){
        Debug.Trace(x + " : " + xxx[i][x]);
    }
}

db.close();


function resultsToArray(result){
    var res = new Array();
    while(!result.EOF){
        var row = {};
        for(var enume = new Enumerator(result.Fields);!enume.atEnd();enume.moveNext()){
            row[enume.item().name] = enume.item().value;
        }
        res.push(row);
        result.MoveNext();
    }
    return res;
}

---