Access a local ODBC database by JavaScrpt

Tuesday, October 28, 2008 by Lance Zhang

It is no recommend because of security issue

<HTML>
<HEAD>
<TITLE></TITLE>
<script language=javascript>
function connectDb()
{
var ConnDB = new ActiveXObject("ADODB.Connection");
ConnDB.ConnectionString="dsn=orc2;uid=webstat;pwd=khkj;";
ConnDB.Open();
var Rs = new ActiveXObject("ADODB.Recordset");
var tempstr="";
Rs.Open("select * from tab",ConnDB,1,3);
while(!Rs.EOF)
{
tempstr = tempstr + Rs("TNAME") + "<br>";
Rs.MoveNext;
}
test.innerHTML=tempstr;
}
 </script>
</HEAD>
<BODY>
<P><div id=test> </div>
<P><INPUT id="button1" type="button" value="Run" name="button1" onclick="connectDb();"></P>
</BODY>
</HTML>

For more information about ODBC and JavaScript:
ODBC Support for Javascript
http://www.freeswitch.org/node/44

0 comments