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:
-
Node.js - use the latest version if possible, but it has been tested on node 0.6.10 and later
-
node-gyp - latest version installed globally (npm install -g node-gyp)
-
python 2.7.x - for node-gyp (make sure it is in the path)
-
Visual C++ 2010 - the Express edition is freely available from Microsoft
-
SQL Server Native Client 11.0 - available as Microsoft SQL Server 2012 Native Client found in the SQL Server 2012 Feature Pack
Build
To build the driver, first node-gyp must configure the appropriate build files.
node-gyp configure
Use node-gyp to build the driver:
node-gyp build
Or to build the debug version:
node-gyp build --debug
Then copy the sqlserver.node file from the build\(Release|Debug) directory to the lib directory. If you would like to use Visual C++ to debug the driver, also copy the sqlserver.pdb file from the same directory.
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.