blocks|key|818287|text|我怀疑您必须用JSON输出web服务来包装您的SQL+Server。从积极的方面来看，这应该是相对容易做到的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|818288|如果node.js中的JavaScript引擎可以做到这一点就好了：(来自How+to+connect+to+SQL+Server+database+from+JavaScript+in+the+browser?)：|offset|length|818289|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;|code-block|syntax|javascript|818290|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/857670/how-to-connect-to-sql-server-database-from-javascript/857688#857688^0|0|11|1X|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

I suspect you'll have to wrap your SQL Server with a JSON outputting web-service. On the positive side, it should be relatively easy to do.

Be nice if the JavaScript engine in node.js could do this: (from <a href="https://stackoverflow.com/questions/857670/how-to-connect-to-sql-server-database-from-javascript/857688#857688">How to connect to SQL Server database from JavaScript in the browser?</a>):

<pre><code>var connection = new ActiveXObject("ADODB.Connection") ;

var connectionstring="Data Source=&lt;server&gt;;Initial Catalog=&lt;catalog&gt;;User ID=&lt;user&gt;;Password=&lt;password&gt;;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;
</code></pre>

blocks|key|818333|text|查看一个新选项：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|818334|https://github.com/orenmazor/node-tds|offset|length|818335|(来自Node.js+and+Microsoft+SQL+Server)|818336|entityMap|0|LINK|mutability|MUTABLE|url|1|https://stackoverflow.com/questions/5156806/node-js-and-microsoft-sql-server/5156855#5156855^0|0|0|11|0|0|3|W|1|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@$D|S|E|T|1|U]]|A|$]]|$1|F|3|G|5|6|7|V|8|@]|9|@$D|W|E|X|1|Y]]|A|$]]|$1|H|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]|O|$5|K|L|M|A|$N|P]]]]

Check out a new option:

<a href="https://github.com/orenmazor/node-tds" rel="nofollow noreferrer">https://github.com/orenmazor/node-tds</a>

(from <a href="https://stackoverflow.com/questions/5156806/node-js-and-microsoft-sql-server/5156855#5156855">Node.js and Microsoft SQL Server</a>)

blocks|key|818477|text|我推荐node-mssql，它是其他连接器的一个很好的包装器，默认情况下是我之前选择的(Tedious)，它带来了更好的接口。这是一种JavaScript实现，没有编译要求，这意味着您可以在windows和非windows环境中工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|818478|如果你不介意引入带有二进制桥的.Net或单声道，另一种选择是使用edge.js。如果您想在node.js中利用.Net库，这将是非常好的|818479|node-tds被抛弃了，node-odbc不能在windows上工作，MS+node-sqlserver驱动程序似乎不能在非windows上工作(并且有一些愚蠢的要求)。|818480|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/patriksimek/node-mssql|1|https://github.com/pekim/tedious|2|http://tjanczuk.github.io/edge/#/|3|https://github.com/orenmazor/node-tds|4|https://github.com/w1nk/node-odbc|5|https://github.com/WindowsAzure/node-sqlserver^0|3|A|0|18|7|1|0|W|7|2|0|0|8|3|D|9|4|13|E|5|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]|$A|13|B|14|1|15]]|C|$]]|$1|D|3|E|5|6|7|16|8|@]|9|@$A|17|B|18|1|19]]|C|$]]|$1|F|3|G|5|6|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]|$A|1E|B|1F|1|1G]|$A|1H|B|1I|1|1J]]|C|$]]|$1|H|3|-4|5|6|7|1K|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]|R|$5|K|L|M|C|$N|S]]|T|$5|K|L|M|C|$N|U]]|V|$5|K|L|M|C|$N|W]]|X|$5|K|L|M|C|$N|Y]]]]

I would recommend <a href="https://github.com/patriksimek/node-mssql" rel="nofollow">node-mssql</a>, which is a nice wrapper for other connectors, the default being my previous choice (<a href="https://github.com/pekim/tedious" rel="nofollow">Tedious</a>) bringing a bit nicer of an interface. This is a JavaScript implimentation, with no compilation requirements, meaning you can work in windows and non-windows environments alike.

Another option, if you don't mind bringing in .Net or Mono with a binary bridge would be to use <a href="http://tjanczuk.github.io/edge/#/" rel="nofollow">edge.js</a>. Which can be very nice if you want to leverage .Net libraries in node.js

<a href="https://github.com/orenmazor/node-tds" rel="nofollow">node-tds</a> is abandoned, <a href="https://github.com/w1nk/node-odbc" rel="nofollow">node-odbc</a> doesn't work with windows, and the MS <a href="https://github.com/WindowsAzure/node-sqlserver" rel="nofollow">node-sqlserver</a> driver doesn't seem to work on non-windows (and has some goofy requirements).

blocks|key|1033474|text|如果从linux连接到Mssql，可以使用node-odbc+(+https://github.com/w1nk/node-odbc+)和freetds+odbc+driver。我在生产中使用它，它比包装web服务更快。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1033475|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/w1nk/node-odbc^0|X|X|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If you are connecting to Mssql from linux you can use node-odbc ( <a href="https://github.com/w1nk/node-odbc" rel="nofollow">https://github.com/w1nk/node-odbc</a> ) with the freetds odbc driver. I am using this in production and its faster than wrapping a web service.

blocks|key|1033498|text|另一种选择，甚至来自微软，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1033499|http://www.microsoft.com/en-us/download/details.aspx?id=29995|offset|length|1033500|或通过odbc的linux+sql客户端驱动程序：|1033501|http://www.microsoft.com/en-us/download/details.aspx?id=28160|1033502|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|1P|0|0|0|0|1P|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@$D|Y|E|Z|1|10]]|A|$]]|$1|J|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|C]]|Q|$5|M|N|O|A|$P|I]]]]

Another option, from Microsoft even,

<a href="http://www.microsoft.com/en-us/download/details.aspx?id=29995" rel="nofollow">http://www.microsoft.com/en-us/download/details.aspx?id=29995</a>

Or a linux sql client driver via odbc:

<a href="http://www.microsoft.com/en-us/download/details.aspx?id=28160" rel="nofollow">http://www.microsoft.com/en-us/download/details.aspx?id=28160</a>

blocks|key|818502|text|2015年的新答案:+ORM包Sequelize现在支持MS，在幕后使用Tedious驱动程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|818503|这是我发现的与Microsoft+SQL+Server交互的最佳方式。|818504|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/sequelize/sequelize|1|https://github.com/pekim/tedious^0|F|9|0|10|7|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

New answer for 2015: The ORM package <a href="https://github.com/sequelize/sequelize" rel="nofollow">Sequelize</a> now supports MS SQL, using the <a href="https://github.com/pekim/tedious" rel="nofollow">Tedious</a> driver under the covers. 

This is the best way I've found to interact with Microsoft SQL Server.

blocks|key|1033606|text|我最近遇到了这个问题，我正在尝试连接托管在远程服务器上的MSSQL。我不得不使用的配置是-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1033607|let+config+=+{
++++user:+'user',
++++password:+'password',
++++server:+'server',
++++database:+'database',
++++"options":{
++++++++instanceName:+'instanceName',
++++++++"encrypt":true,
++++++++"enableArithAbort":true,
++++++++"trustServerCertificate":+true,
+++++++}
};
module.exports=config;|code-block|syntax|javascript|1033608|在SSMS中使用SELECT+@@servicename获取实例名称|1033609|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I recently encountered this problem, I was trying to connect the MSSQL that is hosted on a remote server. The config that I had to use is-
<pre><code>let config = {
 user: 'user',
 password: 'password',
 server: 'server',
 database: 'database',
 &quot;options&quot;:{
 instanceName: 'instanceName',
 &quot;encrypt&quot;:true,
 &quot;enableArithAbort&quot;:true,
 &quot;trustServerCertificate&quot;: true,
 }
};
module.exports=config;
</code></pre>
For getting the instance name use SELECT @@servicename in SSMS

I was wondering if anyone was aware of a way to connect to a Microsoft SQL database from Node.js. I'm aware of the MySQL drivers, but I have data that I need to pull from a MS SQL database and would rather pull directly from Node.js rather than hack a PHP script of some sort in place.

Connecting to a remote Microsoft SQL server from Node.js

SQL数据库

SQL Server

数据库

服务器

MySQL

JSON

我想知道是否有人知道从Node.js连接到Microsoft SQL数据库的方法。我知道MySQL驱动程序，但我有需要从MySQL数据库中提取的数据，我宁愿直接从Node.js中提取，也不愿在适当的地方破解某种类型的PHP脚本。

问从Node.js连接到远程Microsoft SQL server
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从Node.js连接到远程Microsoft SQL serverEN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从Node.js连接到远程Microsoft SQL server
EN