Acess SQL server Data in node js/Failed to connect to localhost:1433 - Could not connect (sequence)

Показать описание

in this video you will see the solution of below errors,
1. Failed to connect to localhost:1433 - Could not connect (sequence).

This is fetch SQL data using node js
or
get SQL data using node js

if you got error Cannot find module 'express' then run command on command prompt
npm install express

if you got error Cannot find module 'mssql' then run command on command prompt
npm install mssql

1. create table
CREATE TABLE [dbo].[tblprod](
[prodcode] [int] NOT NULL,
[prodname] [nchar](10) NULL
)

var express = require('express');
var app = express();

var sql = require("mssql");
// config for your database
var config = {
user: 'sa',
password: 'abc!1234',
server: 'localhost',
database: 'sample'
};

// connect to your database

// create Request object
var request = new sql.Request();

// query to the database and get the records

// send records as a response

});
});
});

});