msnodesql

Microsoft Driver for Node.js for SQL Server


Keywords
sql, database, mssql, azure, sqlserver, tds, microsoft, msnodesql, node-sqlserver
License
Apache-2.0
Install
npm install msnodesql@0.2.1

Documentation

Note

This driver is a native C driver that uses the Microsoft ODBC driver under the hood. If you are looking for a pure javascript driver with no dependencies please check out Tedious.

Microsoft Driver for Node.js for SQL Server

The Microsoft Driver for Node.js for SQL Server allows Node.js applications on Microsoft Windows and Microsoft Windows Azure to access Microsoft SQL Server and Microsoft Windows Azure SQL Database.

This is an initial preview release, and is not production ready. We welcome any feedback, fixes and contributions from the community at this very early stage.

Prerequisites

The following prerequisites are necessary prior to using the driver:

Next install the msnodesql driver

  1. Download the msnodesql driver by using the command ‘npm install msnodesql’. This will install Microsoft’s NodeJS-SQL driver into your project. You should now have a folder called msnodesql inside node_modules. Note: This will only work with Node 0.8.9. If you had newer versions, you will have to downgrade.

  2. Next go to the file explorer and naviage to the the C:\NodeJSSampleProject\node_modules\msnodesql folder and run the executable(.msi file). Note: You will need Visual C++ 2010 Express before you run the executable. This can be downloaded from here.

Test

Included are a few unit tests. They require mocha, async, and assert to be installed via npm. Also, set the variables in test-config.js, then run the tests as follows:

cd test
node runtests.js

Known Issues

We are aware that many features are still not implemented, and are working to update these. Please visit the project on Github to view outstanding issues.

Usage

For now, please see the unit tests for usage examples.

Contribute Code

If you would like to become an active contributor to this project please follow the instructions provided in the Contribution Guidelines.

License

The Microsoft Driver for Node.js for SQL Server is licensed under the Apache 2.0 license. See the LICENSE file for more details.