Tuesday, October 4, 2011

ADODB using JavaScript

var connection = new ActiveXObject("ADODB.Connection") ;
var connectionstring="Data Source=myserver;Initial Catalog=myDB;User ID=testuser;Password=password;Provider=SQLOLEDB";
connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");
rs.Open("SELECT * FROM testtable", connection);
rs.MoveFirst
while(!rs.eof)
{
document.write(rs.fields(0)+" " +rs.fields(1) + "
");
rs.movenext;
}
rs.close;
connection.close;

No comments:

Post a Comment