Базы данных и JavaScript

Через ADO JavaScript позволяет работать с MS Access, MS SQL Server
и с другими базами данных, поддерживающими ADO или ODBC-интерфейс.

<%
Application("CONNECTION_STRING") =
    "Provider=SQLOLEDB.1;Password=123456;"+
    "Persist Security Info=True;"+
    "User ID=sk1;Initial Catalog=sk1;Data Source=localhost";

var connection = Server.CreateObject("ADODB.Connection");
    connection.ConnectionTimeout = 10;
    connection.CursorLocation = 3;
try {
    connection.Open(Application("CONNECTION_STRING"));
    connection.Execute("SET DATEFORMAT ymd");
} catch (e) {
    delete connection;
    throw e;
}

var sql = "INSERT INTO test(name) VALUES('test')";
var cmd = new ActiveXObject("ADODB.Command");
cmd.ActiveConnection = connection;
cmd.CommandType = adCmdText;
cmd.CommandText = sql;
cmd.Execute(sql);
delete cmd;

var sql = "SELECT * FROM test ORDER BY name";
var rst = new ActiveXObject("ADODB.Recordset");
rst.ActiveConnection = connection;
rst.CursorLocation = adUseClient
rst.CursorType = adOpenKeyset;
rst.LockType = adLockOptimistic;
try {
    rst.Open(sql);
} catch (e) {
    delete rst;
    throw e;
}

var form = {};
if (!(rst.EOF && rst.BOF)) {
    while (!rst.EOF) {
        for(var j=0;j<rst.Fields.Count;j++) {
            var fieldName = String(rst.Fields(j).Name);
            var fieldValue = String(rst.Fields(j).Value);
            form[fieldName] = fieldValue;
        }
        rst.MoveNext();
    }
}
else {
    // No records
}

connection.Close();
%>