You can use ADODB:
var oCon;
var strConnect = "DSN=YourDSNHere";
oCon = new ActiveXObject("ADODB.Connection");
oCon.Open(strConnect);
var strSQL = "SELECT SomeField FROM myTable;";
var rsAd=oCon.Execute(strSQL);
Response.Write("First row is, "+ rsAd.Fields("SomeField") );
oCon.Close();