Questions tagged [tedious]

Node Module - Tedious it is used to interact with instances of Microsoft's SQL Server.

Tedious is an implementation of the TDS protocol, which is used to interact with instances of Microsoft's SQL Server.

It is intended to be a fairly slim implementation of the protocol, with not too much additional functionality.

282 questions
0
votes
0 answers

How can I turn this TediousJS response into a stream?

I currently have this code that builds up a 2mb json object. Upon completion it uses res.json(response) and sends the cached data to my client. I envision that this will cause scalability problems if it is not handled in chunks. What do I do to…
Ouwen Huang
  • 1,037
  • 2
  • 9
  • 25
0
votes
2 answers

Node.js with SQL Server

Has anyone had any success getting Node to communicate with a SQL Server database? I've tried all the solutions posted on Stackoverflow (although all relevant questions seem to be about a year old) and none of them have worked. Some of the packages…
Ally
  • 4,894
  • 8
  • 37
  • 45
-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
-1
votes
2 answers

filled array is empty when send back to user

I try to get data from an azure database with SQL and for this I use tedious. When I execute the code, the array "result" gets filled up with data but when de respond sends the array "result" to the user it is empty. Why and how can I solve it? (I…
Bjop
  • 330
  • 4
  • 19
-1
votes
3 answers

Streaming query with mssql and node, very slow the first time

I am using node js 10.16.0 and the node-mssql module to connect to a DB. Everything works fine and my simple queries work fine. If I try to stream data from a query, using the node-mssql example , the first time I execute its very slow. It doesnt…
codebot
  • 517
  • 8
  • 29
  • 55
-1
votes
1 answer

Promise/catch didn't catch promise.reject

My async function returns Promise.reject, but caller can't catch it. I'm using Tedious and Express. What did I mistake? const connection = require('tedious').Connection; const Request = require('tedious').Request; const TYPES =…
sungyong
  • 2,267
  • 8
  • 38
  • 66
-1
votes
1 answer

Unhandled rejection RequestError: The conversion of the nvarchar value '238998679919674' overflowed an int column

I have table 'customers' and table 'conversations' I am pretty new in javascript. Currently, I try to use knex + bookshelf (SQL server database with tedious driver) to join those two tables. I separate those two tables in two models and call it…
Akmal
  • 71
  • 1
  • 2
  • 14
-1
votes
1 answer

Return an object when the promise finishes inside a require

When i was writing this promise to query an sql datbase i was not testing it with require i was just running the js file straight from node in the console. Now i need it to return the data when finishing the loop and I can't figure out how. Promises…
WouldBeNerd
  • 629
  • 11
  • 29
-1
votes
2 answers

does this LEFT OUTER JOIN statement look correct?

I' not getting an error message but i seem to be only getting 5 results no matter what i choose, so this leaves me to beleive that there is something wrong with my SQL statement. I'm usint node.js tedious to connect to sql 2008 r2 database. Previous…
WouldBeNerd
  • 629
  • 11
  • 29
-1
votes
1 answer

node.js tedious ConnectionError: Failed to connect to sqlserverip:1433 crashing express server

I am not able to capture this node.js tedious error ConnectionError: Failed to connect to sqlserverip:1433 which making my express server crash unexpectedly. Can anyone please suggest me what I should do to avoid such…
amulllb
  • 3,036
  • 7
  • 50
  • 87
-1
votes
1 answer

How to make tedious Async in Meteor

I am using this module tedious to connect. I am having issues when I try to populate a collection with the data from MSSQL. My code thus far: http://pastebin.com/q4ByRCbW Meteor.startup(function () { var Request =…
-2
votes
1 answer

Tedious package giving error "undefined is not a function" with es6,React,webpack

I am trying to connect to a remote mysql server using connection strings with the help of tedious library. i converted all my code from react to react-es6. when i try to make a connection as below, i get an error "undefined is not a function". …
Hussian Shaik
  • 2,559
  • 9
  • 37
  • 57
1 2 3
18
19