Skip to content

Instantly share code, notes, and snippets.

@MohitSharma

MohitSharma/ODBC Connection

Created July 24, 2015 05:39
Show Gist options
  • Save MohitSharma/546078cabb6646cece99 to your computer and use it in GitHub Desktop.
Save MohitSharma/546078cabb6646cece99 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ODBC Connection
<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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment