Connecting to remote Sql Server using node tedious

[kimi23]

Hi Pekim,

I am trying to connect to my test database server form my local box. suing tedious connection pool and having great difficulty.,

Can you please help me ASAP.

Thanks heaps.. My code:

var ConnectionPool = require('tedious-connection-pool');
var Request = require('tedious').Request;

var connectionConfig = {
"userName": "user",
"password": "user1",
"server": "test001",
"options": {
"database": "employees"
}
};

var poolConfig = { max: 10, min: 2, idelTimeOutMills:30000 };

var pool = new ConnectionPool(poolConfig, connectionConfig);

pool.requestConnection(function (err, connection) {
if(!err) {
var request = new Request('select 42', function(err, rowCount) {
// Release the connection back to the pool.
connection.close();
});

request.on('row', function(columns) {
  console.log(columns[0].value, 42);
});

connection.on('connect', function(err) {
  connection.execSql(request);
});

}
});