Questions tagged [node-seriate]

A cross platform module for Microsoft SQL Server that wraps node-mssql

More info:

9 questions
5
votes
3 answers

seriate RequestError: SqlContext Error. Failed on step "GetData" with: "Timeout: Request failed to complete in 15000ms

I am trying to run a stored procedure on my SQL database from the node server using seriate. however i get the follwoing error and i am not sure why. I'd really appreciate your help on it. Error: { [RequestError: SqlContext Error. Failed on step…
Nat
  • 789
  • 3
  • 8
  • 15
2
votes
2 answers

seriate node js how close connection

I have written a query to select rows in table using seriate, now the query is able to fetch the results but the command is not exiting unless I do ctrl + c in the git bash window. Is there anyway to close the connection and come out of the session…
rahoolm
  • 733
  • 2
  • 12
  • 22
1
vote
1 answer

'asTable' syntax with the Seriate module in Node

I have an object I'd like to have inserted into a table in my MSSQL DB. According to the Seriate docs on github, this shouldn't be a problem. My setup looks like this: apiRoute.js module.exports = function(express, schema) { var apiRoute =…
Nilzone-
  • 2,766
  • 6
  • 35
  • 71
1
vote
1 answer

Connecting to SQL Server from Nodejs

I am working on a sample application using Node js and SQL server 2008. To access SQL server from node js am using seriate [http://developer.leankit.com/painless-sql-server-with-nodejs-and-seriate/]. Below is my sample code File ./DBLayer/db.js…
refactor
  • 13,954
  • 24
  • 68
  • 103
1
vote
1 answer

Use Bulk Insert query with Seriate Module in Nodejs

I am using Seriate module in Nodejs for making my Tsql queries. Now I am stuck in implementing bulk insert with it. Seriate documentation dosen't say any thing about bulk inserting. https://github.com/LeanKit-Labs/seriate I am trying different…
Achilles
  • 519
  • 7
  • 27
0
votes
1 answer

What is the best possible approach to connect seriate node.js with a web application

I am actually involved in a POC and looking to build a web app which can display SQL results after hitting a button. Got to know that seriate node.js is a good platform for this. But unable to find out how to link these components. Any help towards…
Mohit Sudhera
  • 341
  • 1
  • 4
  • 16
0
votes
2 answers

How can I parse the output of SQL stored procedure in node js?

I'm calling a stored procedure using seriate to register users and the output JSON like this when the user is created and the first value {"":208} is the generated…
user2374165
  • 13
  • 1
  • 6
0
votes
2 answers

Node.js seriate SQL DB connection issue

I'm trying to connect SQL Server on my local machine and get some data back. Here's my code: var sql = require("seriate"); var config = { "host":"127.0.0.1", "port": "1433", "user": "dba", "password": "test1234", "database":…
user1491987
  • 751
  • 1
  • 14
  • 34
-1
votes
1 answer

Nodejs crashes when database connection fails

While my database server is not available and any function of my node-express rest service like hiExpress is called, Nodejs crashes the node server and console of node reports sql server connection closed I do not want this to happen because…
Sami
  • 8,168
  • 9
  • 66
  • 99