I have used following code :
var sql = require('node-sqlserver');
var connectionString = "Driver={SQL Server Native Client
10.0};Server=(local);Database=v3;Uid=sa;Pwd=sa;";
sql.open(connectionString, function(err, conn) {
if(err) {
console.log(err);
}
else {
var command = "{select * from tblpatientmaster}";
conn.queryRaw(command, function(err, results) {
if(err)
{
console.log(err);
}
else
{
for(var i = 0; i < result.rows.length; i++)
{
console.log(i + ": " + "Key = " + result.rows[i][0]);
console.log(i + ": " + "Culture = " + result.rows[i][1]);
console.log(i + ": " + "Value = " + result.rows[i][2]);
}
}
});
}
});
but getting error :
Can not connect to sql server : error no 53.
Tried changing in connection string and variouse changes in network (TCP/IP
etc) related setting in SQL Server ,but not getting connected
Any help please?
--
Job Board: http://jobs.nodejs.org/
Posting guidelines:
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
