更新时间:2022-03-22 22:20:58
看看这里。它不推荐,它不适用于IE以外的任何其他任何东西,这是非常糟糕的做法,
http://***.com/questions/857670/how-to-connect-to-sql-server-database-from- javascript [ ^ ]
而不是这样做,你应该从服务器端代码(.Net,Java,PHP等)建立数据库连接)。
Have a look here. It's not recommended, it won't work on anything other than IE and it's extremely bad practice,
http://***.com/questions/857670/how-to-connect-to-sql-server-database-from-javascript[^]
Instead of doing this, you should be making your database connections from server-side code (.Net, Java, PHP etc).
试试这个我的朋友,
Try this one my friend,
var connection = new ActiveXObject("ADODB.Connection") ;
var connectionstring="Data Source=<server>;Initial Catalog=<catalog>;User ID=<user>;Password=<password>;Provider=SQLOLEDB";
connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");
rs.Open("SELECT * FROM table", connection);
rs.MoveFirst
while(!rs.eof)
{
document.write(rs.fields(1));
rs.movenext;
}
rs.close;
connection.close;
问候,
Eduard
Regards,
Eduard