The Microsoft Driver for Node.JS for SQL Server is a Node.JS module that allows for the reading and writing of SQL Server data from within Node.JS applications.
Questions tagged [node-sqlserver]
23 questions
73
votes
13 answers
node-gyp build error windows x64: "fatal error LNK1181: cannot open input file 'kernel32.lib'"
Here's what I've done so far on my x64 OS:
Installed Python (v2.7 --specifically 2.7.6) and added it to the system path (C:\Python27)
Installed MS VS C++ 2010 Express Version (I already had VS 2012 but without the C++ component)
Installed the…
Rachael
- 1,965
- 4
- 29
- 55
7
votes
4 answers
Unable to download msnodesql-0.2.1-v0.10-x64.msi
I can't get msnodesql to install.
Originally I tried
npm install node-sqlserver
... and this warns that it has been superceded by msnodesql.
I successfully installed Node.js, iisnode and I see the sample Hello.js being served up (yayee,…
spojam
- 164
- 1
- 3
- 13
4
votes
1 answer
node.js sql server driver - is it still being actively developed?
The Microsoft node.js sql server driver (https://github.com/Azure/node-sqlserver) has not had any commits for 11 months. Anyone know what's going on with this effort? My company is using it actively, but has run across some issues that led me to…
Prague Expat
- 41
- 2
2
votes
2 answers
Using mssql and node-sql to UPDATE
I'm using mssql together with node-sql to build SELECT queries but I can't find any example how to use it to build UPDATE queries. I have an object where properties corresponds to table fields and I would like to update all of them.
Assume:
child:…
Dread Boy
- 772
- 6
- 28
1
vote
0 answers
Got "Module did not self-register" error. when tried to added msnodesqlv8 module in electron
I got error when I had added msnodesqlv8 module in electron.
Uncaught Error: Module did not self-register.
at process.module.(anonymous function) [as dlopen] (ELECTRON_ASAR.js:172:20)
at Object.Module._extensions..node (module.js:598:18)
at…
Gaurav
- 83
- 2
1
vote
0 answers
Nodejs mssql filestream data type returning buffer?
I am storing large files as a filestream in SQL Server. When I query SQL Server, the table shows a long string of data like this for each file/row:
0x504B03041400060008000000210032916F5766010000A5050000130008025B436F6E74656E74...........
When I…
namko
- 627
- 1
- 14
- 27
1
vote
1 answer
Why does my Node.js MS SQL script never end unless I CTRL+C out of it?
The await keyword can only be used inside an async function so I created a main() that is asynchronous and execute it at the global level. Everything runs correctly but then the program sits there in the event loop and never ends. I could add…
Neil C. Obremski
- 18,696
- 24
- 83
- 112
1
vote
1 answer
TypeError: done is not a function query callback
I am trying to save a result of a query into a variable, I have read that you have to use a callback to do this. I am having problems with this process and receiving an error.
function getQryUser(user) {
if (user.chkUserStatus) {
var qryUser…
crod
- 235
- 3
- 5
- 12
1
vote
1 answer
How to execute stored procedure as well as select command using nodejs-mssql
I am using node-mssql (https://github.com/patriksimek/node-mssql) node module to connect my SQL Server.
I have requirement some thing like
declare @isTrue int
exec @isTrue = sp_isFolderExist @name='new folder',@FolderTypeID=1
select @isTrue
How…
Ashish Yadav
- 99
- 3
- 5
1
vote
1 answer
node-sqlserver, Azure Mobile Services and Azure SQL - old rows are returned even after transaction commit
I have following code on server side:
let query = `
BEGIN TRANSACTION FOO_TRAN
EXEC sp1_update ...,
EXEC sp2_insert ...,
EXEC sp3_update ...,
EXEC sp4_delete ...,
...
COMMIT TRANSACTION FOO_TRAN
…
Ginden
- 5,149
- 34
- 68
1
vote
1 answer
Couldn't able to build node-gyp Visual Studio 2013 support
I'm using Visual Studio 2013, and i need to do a example project with msnodesql, I installed node-gyp globally, then i tried to configure the node-gyp using node-gyp configure command, it executed successfully, but when i tried to build the…
Anoop
- 849
- 3
- 13
- 28
1
vote
2 answers
npm install node-sqlserver failing on windows7
Can you plese guide to resolve the error I am getting?
Ater running this on my local environment npm install node-sqlserver
I am getting this error at the end:
gyp ERR! build error
gyp ERR! stack Error: `msbuild` failed with exit code: 1
gyp ERR!…
Dalorzo
- 19,834
- 7
- 55
- 102
1
vote
1 answer
Connecting Sql Server though Node.js
I want to connect to SqlServer through Node.js.
I have tried many ways and many links but nothing is work properly. I want to connect to SqlServer and fetch some data.
Please can someone suggest some steps and code to connect SqlServer 2008. What…
HomeWork
- 263
- 1
- 4
- 14
1
vote
1 answer
Build failing on sqlserver driver for nodejs
I'm trying to install node-sqlserver for my application in the node_modules directory by typing the following command,
npm install node-sqlserver
This is what I get,
npm WARN package.json application-name@0.0.1 No README.md file found!
npm WARN…
painotpi
- 6,894
- 1
- 37
- 70
1
vote
1 answer
Node.js SQL Server driver issue - How to troubleshoot
What is the correct way to troubleshoot this error with Node.js on Windows with the SQL Server driver.
events.js:2549: Uncaught Error: 42000: [Microsoft][SQL Server Native Client 11.0
]Syntax error, permission violation, or other nonspecific…
BuddyJoe
- 69,735
- 114
- 291
- 466