Tuesday, 23 May 2017

I created REST API for SQL SERVER to get the all the record using node.js

Below is code of Node.js for getting the data from SQL server but it give an error "Global connection already exists. Call sql.close() first."

  var express = require('express');
    var app = express();
    app.get('/', function (req, res) {

    var sql = require("mssql");

    var config = {
        user: 'sa',
        password: '',
        server: '', 
        database: 'Test' 
    };

    sql.connect(config, function (err) {

        if (err) console.log(err);
        var request = new sql.Request();
        request.query('select * from TestTable', function (err, recordset) 
         {
              if (err) console.log(err)
              res.send(recordset);
         });
     });
  });
    var server = app.listen(5000, function () {
       console.log('Server is running..');
   });



via Sumant Singh

No comments:

Post a Comment