Thursday, July 2, 2009

Connect to database through JavaScript.

function ConnectToDb()
{

var connection = new ActiveXObject("ADODB.Connection") ;

var connectionstring="Data Source=;Initial Catalog=;User ID=;Password=;Provider=System.Data.SqlClient";

Data Source=MSSQL2005;Initial Catalog=TravelAruba;User ID=aruba;Password=aruba01" ProviderName="System.Data.SqlClient

connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");

rs.Open("SELECT * FROM table", connection);
rs.MoveFirst
while(!rs.eof)
{
document.write(rs.fields(1));
rs.movenext;
}

rs.close;
connection.close;
}

No comments:

Post a Comment