Stack Overflow
Stack Overflow

Questions tagged [node-sqlserver]

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.

23 questions
0
votes
1 answer

Encoding '_sbcs' has incorrect 'chars' (must be of len 128 or 256) when using node-mssql

I am using node-mysql to return a simply dataset, my db table only have 2 varchar fields, when I started my application to querying the data, it throws error 'Encoding '_sbcs' has incorrect 'chars' (must be of len 128 or 256) ' the versions are …
Qianchao Pan
  • 1
  • 2
0
votes
3 answers

Inserting data using Prepare statement doesn't return inserted record

I am using node-sql. recordSet is undefined when i try to insert record in a table using Prepare Statement. Below is the sample line of code. ps.execute(data, function (err, recordSet, affected) { }); Although record is successfully inserted into…
Siraj ul Haq
  • 845
  • 9
  • 25
0
votes
1 answer

Deploying a node app using msnodesql fails on azure Web apps site

I tried to run a node.js code on Azure Web apps using msnodesql to Azure SQL Database, but it fails. I checked the comment ( node.js + azure sql database ), but it didn't work yet. Now I checked node version on Azure by the tool "console" on the…
Hideki Nishimura
  • 3
  • 2
0
votes
0 answers

Node js job to fetch data from sql server and insert into mysql database

I want to develop a task in node js which fetch data from table in sql server and insert into table in mysql. This task need to run continuously after certain time period (say after each 5 seconds). Please guide me to achieve this. JS code var sql =…
Azad Shaikh
  • 61
  • 5
  • 13
0
votes
1 answer

Microsoft's Node.JS driver does not work

I tried following this but with no luck. http://blogs.msdn.com/b/sqlphp/archive/2012/06/08/introducing-the-microsoft-driver-for-node-js-for-sql-server.aspx Every time I try to build it, it fails. Does anyone have any ideas as to why does it fail to…
Yuchen Xu
  • 13
  • 2
0
votes
2 answers

Can't set msnodesql to work

Ok, i've tryed everything here. I did installed msnodesql from -https://github.com/Azure/node-sqlserver and -http://www.microsoft.com/en-us/download/details.aspx?id=29995 following every line of instruction on installation. build with…
Janx from Venezuela
  • 1,147
  • 1
  • 10
  • 12
0
votes
1 answer

Weird error in Node.js while inserting data into SQL Server database

I'm trying to inset a data into a SQL Server database using the following command:- CREATE TABLE table_simupush ( id int NOT NULL IDENTITY(1,1) PRIMARY KEY, priority int NOT NULL ) I can inset data by following code while test it…
masiboo
  • 4,537
  • 9
  • 75
  • 136
0
votes
0 answers

Node.js SQL Server driver issue - fails to install

I am using Node.JS version v0.10.13. I am using Python version 2.7.2. I am using node-gyp version 0.10.2 according to the package.json file. Output from trying to install node-sqlserver via npm http://pastebin.com/N262mMR8 Output from trying to…
BuddyJoe
  • 69,735
  • 114
  • 291
  • 466
1
2