如何使用JavaScript连接到数据库???
问题描述：
我需要使用javascript连接到数据库[sql server 2000或2005].如果有人对此有想法，请提供解决方案.
问候，
Jawwad！
I need to connect to database [sql server 2000 or 2005] using javascript. If any one has idea about this, please provide a solution.
Regards,
Jawwad!
答
您可以使用ADODB:
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();