how to connect a SQL database with node

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

i want to connect a sql db with node and i find this npm package
https://www.npmjs.com/package/mssql[^]
and i started but i didn't make to

Java

var sql = require('mssql');

var config = {
    user: '',
    password: '',
    server: 'localhost', // You can use 'localhost\\instance' to connect to named instance
    database: 'dbUsers'
}

sql.connect(config, function(err) {
// error check
  throw err; // not sure about this

    var request = new sql.Request();
    request.query('select * from tblUsers'); // or request.execute(procedure);

    request.on('recordset', function(columns) {
        // Emitted once for each recordset in a query
    console.log(columns);
    });

    request.on('row', function(row) {
console.log (row);
    });

});

Posted 11-Feb-15 22:36pm

Member 11446760

Updated 12-Feb-15 4:37am

Maciej Los

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

harsimranb · Answer 1 · 2015-02-12T04:58:00

Just to be on the safe side, can you test the connection parameters to make sure they're correct? I found this open source project on the internet: DbAccess Tester[^].

Second, make sure "Mixed mode" authentication is enabled in Sql Server. And also that the user has login permission. This article covers both: http://kb.kcsi.ca/Knowledgebase/How-to-Change-from-Sql-Server-Windows-mode-to-Mixed-Mode-SQL-SERVER-2008[^]

*Note: You do not need to change the password. Also, the user doesn't have to be sa.

Finally restart management studio by right clicking the server name and clicking "Restart". Wait a few moments for the service to restart before proceeding.

Let me know if this doesn't help. We can then diagnose further.