Stack Overflow
Stack Overflow

Questions tagged [node-mssql]

node-mssql MSSQL database connector for Node.js.

https://tediousjs.github.io/node-mssql/

An easy-to-use MSSQL database connector for Node.js.

There are some TDS modules which offer functionality to communicate with MSSQL databases but none of them does offer enough comfort - implementation takes a lot of lines of code. This module make work as easy as it could without losing any important functionality. node-mssql uses other TDS modules as drivers and offer easy to use unified interface. It also add extra features and bug fixes.

202 questions
0
votes
2 answers

node js msssql connection error

I am trying to connect mssql server with node.js using mssql package. (https://www.npmjs.org/package/mssql). And I am getting following error. But my server name not xc-pc, my server name is xc-pc\r2. is there any problem connect to msseql server…
onder
  • 795
  • 3
  • 14
  • 32
0
votes
1 answer

¿How can I connect node.js with mssql server with module mssql?

That is my code: var express = require('express'); var http = require('http'); var app = express(); var sql = require('mssql'); var path = require('path'), html5 = require('ejs').__express; app.set('port', process.env.PORT ||…
Dj_System
  • 59
  • 6
0
votes
2 answers

Node.js with SQL Server

Has anyone had any success getting Node to communicate with a SQL Server database? I've tried all the solutions posted on Stackoverflow (although all relevant questions seem to be about a year old) and none of them have worked. Some of the packages…
Ally
  • 4,894
  • 8
  • 37
  • 45
-1
votes
1 answer

pool.request() is not a function

enter code here **my dbconnection.js** const sql = require("mssql"); const config = { user: 'sa', password: 'abhi', server: 'ABHI\\MSSQLSERVER01', database: 'online_video_streaming' }; const poolPromise =new…
abhilash musti
  • 17
  • 5
-1
votes
3 answers

Streaming query with mssql and node, very slow the first time

I am using node js 10.16.0 and the node-mssql module to connect to a DB. Everything works fine and my simple queries work fine. If I try to stream data from a query, using the node-mssql example , the first time I execute its very slow. It doesnt…
codebot
  • 517
  • 8
  • 29
  • 55
-1
votes
2 answers

Why do async functions not work within a controller's get() handler?

I am using Node and Express with the the mssql npm package to connect to an SQL Server database. I do this in my app.js file which sets up a global variable to create a connectionPool to the database like so (I omitted some boilerplate stuff for…
volume one
  • 6,800
  • 13
  • 67
  • 146
-1
votes
1 answer

How to replace few characters in SQL Server and node js

I need to replace following characters in two places (nodejs app and SQL Server database). Characters are: - ( , . ) [ ] _ String can be in any language like English, Japanese etc. Node Js and SQL server both has replace in-built function and I am…
Anil
  • 1,669
  • 5
  • 19
  • 44
1 2 3
…
13
14