Stack Overflow
Stack Overflow

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
77
votes
12 answers

Node.js MSSQL tedius ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED

I am trying to connect to MSSQL 2012 using NodeJS with the mssql connection interface. When attempting to connect I get the following error: { [ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED] name: 'ConnectionError', …
Matt Carrier
  • 5,602
  • 6
  • 26
  • 30
73
votes
15 answers

Node.js and Microsoft SQL Server

Is there any way I can get my Node.js app to communicate with Microsoft SQL? I haven't seen any MS SQL drivers out there in the wild? I'm putting a very simple app together and need to be able to communicate with an existing MS SQL database…
Khuram Malik
  • 1,475
  • 3
  • 18
  • 30
30
votes
2 answers

disable updatedAt (update date) field in sequelize.js

I used sequelize-auto to generate schema, and I tried to use findOne() and I got this error: Unhandled rejection SequelizeDatabaseError: Invalid column name 'updatedAt'. in my database table, there is no field updatedAt. for example, my table name…
yozawiratama
  • 4,209
  • 12
  • 58
  • 106
15
votes
1 answer

Colab: Google drive file stream access permission is a hassle. Is there a better way?

I use Google Colab extensively. In order to get an easy access to files in my Google drive, I mount the drive to the file system of the virtual machine that runs Colab. Like that: from google.colab import drive as…
Ori Mosenzon
  • 511
  • 2
  • 9
14
votes
6 answers

Cannot connect to SQL Server with Node.js and Tedious

When I try to use Node.js and Tedioius to connect to a local SQL Server instance I get this error: { [ConnectionError: Failed to connect to XXXXX:1433 - connect ECONNREFUSED] name: 'ConnectionError', message: 'Failed to connect to XXXXX:1433 -…
loganhuskins
  • 1,399
  • 3
  • 15
  • 33
10
votes
1 answer

NW.js / Node.js throws "SSL routines:ssl_choose_client_version:unsupported protocol" error when using node-mssql / tedious

I found the answer to this problem already and just want to document my finding. When using recent versions of NW.js (and Node.js), I was having problems with the node-mssql / tedious module. Even a task as simple as connecting to a SQL Server…
toyssamurai
  • 561
  • 4
  • 13
9
votes
3 answers

Node Sequelize (MSSQL) - Login failed for user ''

I've come across several posts for this question however, none of them seem to have an actual answer. Several ideas, yet none of them work. After digging around both the Sequelize and Tedious packages and watching my config get passed down…
rimraf
  • 3,925
  • 3
  • 25
  • 55
9
votes
3 answers

How to convert node.js date to SQL Server compatible datetime?

I have a Web Api using express and Tedious to store some data on Azure SQL database. With nvarchar types and int types it works well, but when I try to save DateTime value I get an error message: Insert into Proxy (Ip, RequisitionDate) values ('1',…
gog
  • 11,788
  • 23
  • 67
  • 129
8
votes
6 answers

Tedious or Sequelize uses the wrong syntax for `findOne()`

I am using Sequelize with Tedious to access SQL Server 2008. When I do a sequelizeModel.findOne() I get this exception - Unhandled rejection SequelizeDatabaseError: Invalid usage of the option NEXT in the FETCH statement. I know SQL Server 2008…
Jeremy
  • 2,970
  • 1
  • 26
  • 50
6
votes
4 answers

Error: Please install tedious package manually

I'm getting this error when I run my node app that used sequelize library to connect with MSSQL database. I've tried installing tedious manually both locally and globally but the error is still there. full stack of the error is below: Error: Please…
Ahmed Mujtaba
  • 2,110
  • 5
  • 36
  • 67
6
votes
1 answer

SQL Server connection timeout error in nodejs mssql

Always getting following error after couple of SQL statement execution. I am using var sql = require("mssql"); (node:12240) [DEP0064] DeprecationWarning: tls.createSecurePair() is deprecated. Please use tls.Socket instead. warning.js:18…
Furqan Misarwala
  • 1,743
  • 6
  • 26
  • 53
6
votes
4 answers

Connect to SQL Server with mssql for node.js

I got a error message when I connect to SQL Server with mssql module for node.js. [Error: connection to 192.168.1.101\sql:1433 - failed Error: getaddrinfo ENOENT] var config = { //driver: 'msnodesql', user: '...', password: '...', …
user3209808
  • 83
  • 1
  • 1
  • 5
5
votes
2 answers

Using Node.js to connect to Microsoft SQL Server 2008 (MSSQL) database

Possible Duplicate: Connecting to a remote Microsoft SQL server from Node.js I'm looking for an up-to-date explanation of how to connect to a MS SQL Sever 2008 using Node.js (v0.5.7) I have tried both Node.js projects on GitHub…
paperclip
  • 2,280
  • 6
  • 28
  • 39
5
votes
1 answer

Database connection using tedious

What is the recommended way to establish database connection and close it properly in Node.js using tedious? For each and every request we are creating new connection and processing the request then closing them in callback. app.get('/getData/:id',…
Hari Prasath
  • 111
  • 1
  • 2
  • 8
5
votes
2 answers

node mssql temp table lost - RequestError: Invalid object name '#myTempTable'

I'm using node-mssql and connecting to a the 2017 sql server from docker. Issue Throughout my script, I've put var test = await dbRequest().batch("SELECT * FROM #myTestTable"); Intermittently, I get the error RequestError: Invalid object name…
Jason
  • 15,064
  • 15
  • 65
  • 105
1
2 3
…
18 19