Nose Picker's Maven

    node-sqlserver-unofficial

    1.4.0 • Public • Published

    Unofficial binary distribution of node-sqlserver

    node-sqlserver is a C++ Node.js module used to connect to MS SQL and Azure SQL databases developed by Microsoft. It can be found on npm under the name msnodesql.

    This is an unofficial binary distribution of that driver. Here's why you'd want to use it instead of the official one:

    • No need to compile from source (which requires Visual Studio and totally confuses people).
    • It runs on both x86 and x64 and with node versions 0.8 and 0.10.
    • No weird workarounds needed to run on Azure web sites.

    Use it on your projects via npm

    $ npm install node-sqlserver-unofficial
    

    Dependencies

    To try this out locally on your machine, you'll need

    Testing

    test/ is a deployable Azure website that queries an Azure SQL database and displays the result like so

    node v0.10.25 ia32.
    Query result - 1
    

    Or, in case something goes wrong, an error message like so

    node v0.10.25 ia32.
    Query Failed
    Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'SELECT'.
    

    The environment is specified in package.json and server.js contains the code.

    Before running this, connectionString in server.js must be set to your SQL Azure login credentials. An example would be

    var connectionString = "Driver={SQL Server Native Client 11.0};Server=tcp:?.database.windows.net,1433;Database=?;Uid=?;Pwd=?";
    

    I also recommend to run it locally before deploying it to Azure. Running

    $ npm install
    

    in test/ will resolve the dependencies to test/node_modules/, after which running

    $ node server.js
    

    and accessing http://localhost:1337 will display the result.

    Copyright and license

    This derivative work is hereby released under the MIT license, as made possible by the terms of the Apache 2.0 license of the original node-sqlserver.

    Terms available for review in LICENSE.

    This work is not affiliate with or endorsed by Microsoft in any way.

    Install

    npm i node-sqlserver-unofficial

    DownloadsWeekly Downloads

    7

    Version

    1.4.0

    License

    none

    Last publish

    Collaborators

    • jorgeazevedo