How to connect to Microsoft SQL Server database using NodeJs

-A quick overview on SQL Server configuration, in order to get connected through Node.Js
-Using "mssql" npm package to connect to SQL Server using Node.Js
-How to use "Connection" object to connect to SQL Server
-How to use "Request" object to execute SELECT statement and fetch results
-How to handle SQL Server Connection Errors (from Node Js)
-How to handle SQL statement execution Errors (from Node Js)

[arifmay]

For new versions of MSSQL instead of "var conn = new sq.Connection(dbConfig);" please write "var conn = new

Thank you very much for It helped me a lot!

[hydaralee]

After 3 days finally got something useful that really worked thanks for very simple and perfectly explained example.

[mdeveljexplorer]

After spending hours trying different things including checking the TCP settings, I realised that TCP was not enabled ! Thanks to you i checked it and now everything works !!

[HendersonHarrisson]

Thanks a lot after a whole day trying to get it work finally found this.

[hichemchtara]

thanks man to share, that helped me go ahead and use VS2017 to develop node.js & sql server !!!
but I used seriate when I read a little review between different MS SQL - NPM libraries, it convinced me to go to seriate

[Fguzman]

Amazing video! Understood everything and connected to my database successfully

[arasdestructores]

Man you are awesome, can't find any video of this kind 👌👌👌👍

[divyeshwaren]

omg thanks i had the tcp/ip disabled by default so i had connection issues and now its working thx a lot

[emmquin]

Very Clear. Got it right away!. Thanks

[dheerajnagar]

Thank you so much... I was working on it since Thanks a lot

[peacefreedom]

Thanks a lot.. you made it really simple 😃

[nigelnaicker]

does anyone know how i would return a single column and row of data, essentially assign a single value to a variable and display that in an alert ?

[athira]

Hi, I am using sql express edition, the sql agent never runs, so still node js can connect to sql ?

[SaladoElFede]

Can I use this as connector for strongloop/loopback APIs ? Because their loopback-mssql-connector sucks, and requires suscription

[SatishDubeyG]

Very good tutorial, it worked perfectly

[e.sharathnarayana]

Hi sir is this package use secure communication between node and SQL server like SSL in web application

[milanwillems]

I'm getting the error: req.query("...") is not a function? Any ideas?
It worked before in a Node console application, but now I'm using it as an API in a MEAN stack application and now it gives this error.
Thanks in advance!

[daryazat]

Hi! sorry but i cant find the sql server 2k14 in the server list, only the sql server vss writer.. would I still be able to work or how start/find this service?

[basselalshayeb]

thank you very much >>
but i have a problem when trying to insert i did insert known values but i want to insert unknown data using @ i don't know how to do this

[Ashokkumarg]

The services are not available in those window? Even I though I have the Server installed in my machine