且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何从javascript连接到SQL Server数据库?

更新时间: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