Try the below code.. it is working on my local...
<script language="javascript" type="text/javascript">
function getsqltable()
{
var strtable;
var connection = new ActiveXObject("ADODB.Connection");
var connectionstring = "Persist Security Info=False;Data Source=****;Initial Catalog=****;User ID=****;Password=****;Provider=****";
connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");
rs.Open("select top 10 * from person_info", connection);
rs.MoveFirst
strtable='<table cellpadding=0 cellspacing=0 width=75%>';
while (!rs.eof)
{
strtable+='<tr>';
strtable+='<td>'+rs.fields(0)+'</td>' + '<td>'+rs.fields(1)+'</td>' + '<td>'+rs.fields(2)+'</td>' + '<td>'+rs.fields(3)+'</td>'
strtable+='</tr>';
rs.movenext;
}
strtable+='</table>';
rs.close;
connection.close;
document.getElementById('htmltable').innerHTML=strtable;
}
</script>
<input type="button" onclick="getsqltable();" value="Click Me" />
<div id="htmltable">
</div>