Questions tagged [tediousjs]
10 questions
2
votes
3 answers
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:…
Pieter Geelen
- 528
- 2
- 11
1
vote
0 answers
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.
But now im trying to retrieve all users in my…
alle19af
- 11
- 3
1
vote
0 answers
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 in each object in array to SQL.
To do this, I've…
Lucaso
- 37
- 4
0
votes
2 answers
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 the server. Their required method of use is to…
Hassaan
- 1,561
- 1
- 9
- 15
0
votes
0 answers
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 and able to run the tests from the Cypress App…
Bijo Joseph
- 31
- 1
0
votes
0 answers
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(cmd)
{
var config = {
server:…
A.G.
- 2,089
- 3
- 30
- 52
0
votes
1 answer
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: {
type: 'default',
options: {
…
jsanchezs
- 1,992
- 3
- 25
- 51
0
votes
1 answer
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 closed"
Example: when this api called concurrently the…
Niyaz
- 2,677
- 3
- 21
- 40
0
votes
2 answers
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. Sending the parameters via AJAX jQuery…
Dong
- 328
- 1
- 3
- 16
-1
votes
1 answer
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…
marcelo.delta
- 2,730
- 5
- 36
- 71