287 questions
0
votes
1
answer
91
views
In nodeJS / SQL Server to bulk insert geometry with SRID?
I need to do a bulk insert (via bcp) into a SQL Server table with geometry data. I figured out how to get the operation working generally, however, there are a few criteria/issues that I have been ...
0
votes
0
answers
62
views
Connection issues with Node.js and SQL Server
I am facing a login failure issue when trying to connect my Node.js application to SQL Server 2019 using the tedious package. Despite configuring my authentication and using Windows Authentication, ...
0
votes
2
answers
95
views
Module tedious has no exported member ColumnValue
I test a web application with typescript and playwright. So I read and write data to and from a SQL Server 2019 database. Therefore I use tedious. Since yesterday I used the version 11.0.8 and all ...
0
votes
0
answers
47
views
Does node-mssql tedious support column encryption?
I'm currently using the node-mssql module to connect to SQL Server. Does the latest version of this module support 'Column Encryption / Always Encrypted' feature of SQL Server? If yes, how do we use ...
0
votes
0
answers
76
views
Sequelize sync SQL Server database
I have a question regarding the sync method in Sequelize with SQL Server. To summarize the problem: I have a model with a unique column, and when the table doesn't exist or the database is empty, the ...
1
vote
0
answers
58
views
error connecting the sms database using the npm tedious package
Please help me, I've been suffering for several hours, but I can't connect to the database in SQL Server Management Studio 20. I have already configured SQL and enabled TCP IP, but it still does not ...
0
votes
0
answers
956
views
Keep getting RequestError: Timeout: Request failed to complete in 15000ms error
I am connecting to a SQL Server using the mssql node library https://www.npmjs.com/package/mssql#connections-1. When I try to run a long stored procedure, I keep getting a timeout error even though I ...
0
votes
0
answers
125
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
...
1
vote
0
answers
106
views
Can't make sense why ConnectionError: Data source name not found and no default driver specified
I need to process data from an internal SQL Server database using NodeJs (version 20.*). Connection to the database has to use Windows Authentication, thus I opted for the Tedious mssql and the ...
1
vote
0
answers
188
views
Sequelize update() with 'returning: true' not finding Types if code is in NPM package
I am trying to get [email protected] to return an updated object (Azure Function v4, Typescript, [email protected], Azure SQL Server) as per update() option returning: true.
See the commented out line ...
2
votes
1
answer
666
views
Binding dynamic array parameter values for SQL with NodeJS
To avoid SQL injection with MS SQL Server and Node.js, I typically bind parameters, with something like the following:
let pool = await sql.connect(config)
await pool.request()
.input('ID', sql.Int, ...
0
votes
0
answers
645
views
[SequelizeAccessDeniedError]: Login failed for user, [Nodejs + Sequelize]
I'm having this issue with my SQL Server. I have a Nodejs server that connects to (for now) a SQL Server database.
The problem is that it doesn't allow me to authenticate...
But the strange thing (at ...
0
votes
0
answers
22
views
MSSQL connection from other device in nodejs [duplicate]
I'm new in nodejs and microsoft sql. I've created a simple project which uses mssql in my localhost.
And I connected it in my app.js with 'tedious', and everything works perfect.
var Connection = ...
0
votes
0
answers
1k
views
Node-js Tedious connection with Oracle DB
I need to create a connection to an Oracle database with the Tedious library in node js.
When i run the file this is what it return ' ConnectionError: Connection lost - socket hang up ',
I don't know ...
0
votes
1
answer
210
views
Cypress/tedious/mssql Conversion failed when converting date and/or time from character string
I get this error when I try to execute a simple SQL statement that properly works on the db.
The table:
hd_date | hd_name
2025-04-21 | Ostermontag
2025-06-09 | Pfingstmontag
This works:
var sql ...