<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<script>
function ConnectToDb()
{
var connection = new ActiveXObject("ADODB.Connection") ;
var connectionstring="Data Source=MSSQL2005;Initial Catalog=xxxx;User ID=xxx;Password=xxx;Provider=SQLOLEDB";
connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");
rs.Open("SELECT * FROM [Entity].[TempProviders]", connection);
rs.MoveFirst
while(!rs.eof)
{
document.write(rs.fields(1));
rs.movenext;
}
rs.close;
connection.close;
}
</script>
</HEAD>
<BODY>
<table><tr><td><input type="button" value="connect" onclick="ConnectToDb()">
</td></tr></table>
</BODY>
</HTML>
No comments:
Post a Comment