11 questions
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 ...
- 469
1
vote
2
answers
5k
views
Connecting Sequelize to MSSQL with Windows Authentication
I need help with the right libraries to connect Sequelize to MSSQL database using Windows Authentication.
I have a requirement for a client where I cannot use passwords to connect to the database on ...
- 1,591
0
votes
0
answers
311
views
DB connectivity failure in Cypress while running from console
I was trying to connect MSSQL from Cypress and finally got a solution by following the steps provided in this link:
https://github.com/cypress-io/cypress/issues/6621
The solution worked perfectly fine ...
- 11
0
votes
0
answers
2k
views
RequestError: Requests can only be made in the LoggedIn state, not the Connecting state
Using Tedious to connect to MSSQL DB. In the code below, I get the error:
RequestError: Requests can only be made in the LoggedIn state, not the Connecting state
exports.exec_sql_cmd = async function(...
- 2,169
0
votes
1
answer
1k
views
Tedious sql query returning empty object (can´t return custom array and callback not working)
Im using Tedious in Node JS to return a simple SQL Query :
var Connection = require('tedious').Connection;
var config = {
server: 'myserver.database.windows.net',
authentication: {
...
- 2,076
-1
votes
1
answer
1k
views
How to use mssql connection using ip/instance?
I'm trying to connect to a production SQL Server instance but it fails to connect.
Could anyone help?
I'm grateful for the community's attention.
.env:
MSSQL_SERVER=ip/instance
MSSQL_PORT=1433
...
- 3,102
1
vote
0
answers
174
views
I want to resolve all rows from request.on('row) in node.js - but its only possible with one row
I am working in node.js using tedious package and have connected to my database, (working with HTTP triggers).
The other Get requests i have made so far works - when its only one row im asking for.
...
- 11
2
votes
3
answers
1k
views
Query works but cant retrieve the data
I am new to Node.js (3 days total experience). I am using Node.js and the tedious package to query a database (azure SQL). I use the example as explained here: https://learn.microsoft.com/en-us/azure/...
- 548
1
vote
0
answers
428
views
SQL Tedious Loop through object of array and execute insert statement function error Request is not a constructor
I'm new to Js, and would appreciate some help.
Currently, via tedious js, I've written a sql function that passes an insert statement that loops through an array of objects and inserts each property ...
- 37
0
votes
1
answer
543
views
node mssql concurrent request resulting "Connection is closed"
I am using mssql package of node js and each route i am creating a new connection and performing the transactions, when i call two apis parallelly from client end the mssql throws "Connection is ...
- 2,923
0
votes
2
answers
2k
views
How to run a sql query in Tedious supplying multiple values for the sql in operator?
The code below works if I supply only one parameter. If I select Germany and Mexico from the dropdown nothing is returned by the query despite data existing in the table
The code on the front-end. ...
- 328