jsHarmony Database Connector for SQL Server
npm install jsharmony-db-mssql --save
var JSHmssql = require('jsharmony-db-mssql');
var JSHdb = require('jsharmony-db');
var dbconfig = { _driver: new JSHmssql(), server: "server.domain.com", database: "DBNAME", user: "DBUSER", password: "DBPASS" };
var db = new JSHdb(dbconfig);
db.Recordset('','select * from c where c_id >= @c_id',[JSHdb.types.BigInt],{'c_id': 10},function(err,rslt){
console.log(rslt);
done();
});This library uses the NPM mssql library. Use any of the connection settings available in that library.
- 1.0.0 Initial release