Connecting to remote Sql Server using node tedious

[kimi23]

Connecting to remote Sql Server using node tedious

[pekim]

From a quick look, I can't see anything obviously wrong. Can you provide some details of what happens?

[kimi23]

Just can't connect . Do I need to set the port ??

Regards,
Dhaval

On 30/12/2012, at 11:14 PM, "Mike D Pilsbury" [email protected] wrote:

From a quick look, I can't see anything obviously wrong. Can you provide some details of what happens?

—
Reply to this email directly or view it on GitHub.

[pekim]

The port will default to 1433, so you shouldn't need to specify it, unless you've configured a different port.

Is connection successful if connection pooling is not used?

Can you enable some debugging please? Something along these lines.

var connectionConfig = {
  "userName": "user",
  "password": "user1",
  "server": "test001",

  "options": {
    "database": "employees",
    debug: {
      packet: true,
      data: true,
      payload: true,
      token: true,
      log: true
    }
  }
};

// Note, idleTimeoutMillis was spelt incorrectly, but that
// should not cause your problem.
var poolConfig = { max: 10, min: 2, idleTimeoutMillis:30000, log: true };

...

connection.on('debug', function (message) {
  console.log('debug=> ' + message);
});

[kimi23]

Thanks heaps I will try n let u know tomorrow . Happy new year mate .

Regards,
Dhaval

On 31/12/2012, at 6:31 PM, "Mike D Pilsbury" [email protected] wrote:

The port will default to 1433, so you shouldn't need to specify it, unless you've configured a different port.

Is connection successful if connection pooling is not used?

Can you enable some debugging please? Something along these lines.

var connectionConfig = {
"userName": "user",
"password": "user1",
"server": "test001",

"options": {
"database": "employees",
debug: {
packet: true,
data: true,
payload: true,
token: true,
log: true
}
}
};

// Note, idleTimeoutMillis was spelt incorrectly, but that
// should not cause your problem.
var poolConfig = { max: 10, min: 2, idleTimeoutMillis:30000, log: true };

...

connection.on('debug', function (message) {
console.log('debug=> ' + message);
});
—
Reply to this email directly or view it on GitHub.

[kimi23]

Hi Pekim,

Just discovered when we is linked server the 'returnValue' events gets fired twice? Do you know if I can do somehting in the code to stop this?

This is urgent . It will be great if you can reply ASAP!!!

[pekim]

I'm afraid that I've no idea at the moment what might cause this to happen.

If you can provide some debug log out (see #58 (comment)) that might help me.

[kimi23]

Hi ,

I have found a solution to this which is to inspect the value in the 'returnvalue' event and if that is equal to 0 then not worry about executing the code below.

This is a workaround when trying to use sql 2000 and tedious!

Cheers!

[pekim]

Closing, as debug output will be required to get to the bottom of the problem.
Please feel free to re-open if this can be provided.