All Questions
Tagged with sql-server node.js
1,569
questions
-1
votes
0
answers
59
views
Posting a JSON array to Sequelize Update query results in a stalled request
I'm using node and a Sequelize (6.37.1) update query and it is stalling continuously. This is the only query with issues. This is a CRUD app where inputs are contextual so I'm using Ajax to post a ...
0
votes
0
answers
41
views
Node.js and Tedious accessing SQL Server gives "Failed to parse URL" error
I'm writing a simple API to query a SQL Server database.
I have this code in items.js:
var Connection = require('tedious').Connection;
var config = {
server: 'MyServer', //update me
...
0
votes
1
answer
63
views
How to verify MSSQL signbycert in NodeJS
I'm not familiar with cryptography or the PKCS protocol,
but what i need is to crypto.verify succesfully in NodeJS using singature generated in MSSQL signbycert.
by using this as reference: https://...
0
votes
0
answers
32
views
Handling Varbinary Datatype in Node.JS API header with SQL Server
The API program didn't accept a varbinary format for my Node.JS API with a header key and varbinary value to authenticate my API request with Node.JS.
I've tried the straightforward approach by ...
0
votes
0
answers
49
views
Setting up SQL Server 2012 (v11.0.0) in Node.JS v20.15.0 as Backend API or Data Access Layer Structure
I need to set add-ons on my Flutter project, this is a Backend API using Node.JS which will serve as a middleman API for my Flutter project to retrieve and manage data from database in any platform (e....
0
votes
0
answers
63
views
npm install for tedious and msnodesqlv8 fails with node-gyp error
I have been trying to install some modules in my project to query a SQL Server database. I have tried this with msnodesqlv8 and tedious but both give me the same error as shown below. I've tried using ...
0
votes
1
answer
26
views
Connection with SQL Server using NodeJS
The connection string with the username, password, server and database name are shown here:
//imports
const express = require('express');
const mssql = require('mssql');
const body_parser = require('...
0
votes
0
answers
40
views
ConnectionError in SQL Server
I'm connecting NodeJs with SQL Server and get this error:
ConnectionError: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at PrivateConnection.callback2 (...
0
votes
1
answer
72
views
SQL Server Connection Problem While Using Express and Node Js
I have been trying to connect to the SQL Server with node.js. I am using express but I cannot connect to my database.At first I was getting a problem about ISS and I was able to solve it but now the ...
0
votes
0
answers
38
views
How to Connect Node.js Web Application to SQL Server Database Requiring VPN Access?
I'm trying to connect my web application to my SQL Server database, but I am facing a challenge. My database is hosted on a physical server within my corporation, and my web application is hosted on a ...
0
votes
0
answers
43
views
Issue with node and mssql the query execution function returns a response twice
Here's the part related to query execution
const sql = require('msnodesqlv8');
const connectionString = "******************************";
function exeQuery(query, params, callback) {
...
0
votes
0
answers
53
views
Difference between ES6 Tagged template literals and Input?
In mssql,
ES6 Tagged template literals uses this syntax:
return sql.query`select * from mytable where id = ${value}`
Input uses this syntax:
request.input('input_parameter', sql.Int, value)
In terms ...
0
votes
0
answers
65
views
connection.on is not a function
i get the error , i dont understand, it works for normal queries, but for procedures, i get this error
TypeError: connection.on is not a function
at D:\project_digital\backend\node_modules\mssql\lib\...
0
votes
0
answers
57
views
ConnectionError: Login failed for user '' when using msnodesqlv8 driver in Node.js
I'm encountering an issue with my Node.js application while attempting to connect to a Microsoft SQL Server database using the mssql/msnodesqlv8 package. Whenever I try to establish a connection, I ...
0
votes
0
answers
51
views
Can't connect to AWS SQL Server from local machine using node
I have created a AWS RDS SQL Server database. I can access the same from SSMS. However, the same fails if I try to connect using Node JS.
Here is a snippet of the code.
const sql = require("mssql&...