Questions tagged [tedious]

I am currently working with an array of customer objects that I need to insert into a SQL database. These customer objects are retrieved from the request data. For this task, I am utilizing Tedious for handling the request and Tedious Connectionpool to ma ...

Currently, my setup involves using nodeJs as the backend language and sql server as the database. While I have managed to delete whole table rows from the database successfully, I am facing a challenge when it comes to deleting a specific row. Here is the ...

Earlier today, I executed npm install and the node_modules directory was created with all the necessary files. However, a few hours later, when I ran the same command with the same package.json file, there were no errors, but the node_modules directory wa ...

After adding my IP to the whitelist, I successfully connected to a Google Cloud Platform SQL Server instance using the sqlcmd utility in my terminal. sqlcmd -S <ip-address> -U <username> -P<password> However, when attempting the same co ...

My task involves using Tedious in Node JS to execute a basic SQL Query : var Connection = require('tedious').Connection; var config = { server: 'myserver.database.windows.net', authentication: { type: 'default', options: { ...

During my attempt to set up sequelize and then tedious, I proceeded with the command npm install sequelize. Following the installation process, the Solution Explorer unexpectedly displayed an extensive list of packages suffixed by (not listed in package.js ...

I am relatively new to Node.js and currently working on a Node.js - Express solution as a back-end for an AngularJS web application. My goal is to send an email when the MSSQL database query returns specific information. I have successfully implemented thi ...

Is there a way to pass the response data from one SQL Server stored procedure into another stored procedure for logging purposes? I've attempted different methods but encountered issues with connection pools and errors like HTTP Status: 500, subStatu ...

I am currently developing my API server using Express JS, and I am connecting to my SQL Server DB with tedious. For each request logic, I am creating a new tedious Connection object, establishing a connection to the DB, executing the query, and then closi ...

So I have been working on developing a NodeJs application on my Windows machine. Recently, I decided to deploy it on Azure cloud and set up a SQL Server instance. During the testing phase, where the node app was running locally and the SQL Server was conn ...

When attempting to connect to a local SQL Server instance using Node.js and Tedioius, I encounter the following error: { [ConnectionError: Failed to connect to XXXXX:1433 - connect ECONNREFUSED] name: 'ConnectionError', message: 'Failed to connect to ...

I'm struggling to figure out how to properly time the execution of a python script following the completion of a SQL Server stored procedure via a router.post (express4/tedious): router.post('/post/create', textParser, function (req, res) { ...