Comments (4)
What messages are emitted from the connection's info and error events?
I understand that azure only supports SQL Server connections with encryption. So the first question is, have you enabled encryption on the connection? The encrypt
property in the connection config options
needs to be true
. (http://pekim.github.com/tedious/api-connection.html#function_newConnection)
var config = {
...
options: {
encrypt: true,
...
},
...
};
It's possible that even with encryption enabled, there's a problem with the encryption. I've had mixed results trying to get it to work.
To try and get a better understanding of the problem, can you enable some debugging logging please?
In your connection config object can you enable all debug logging options please?
var config = {...}
config.options = {}
config.options.debug = {
packet: true,
data: true,
payload: true,
token: true,
log: true
}
Then on the Connection object, log debug
events.
connection.on('debug', function(text) }
console.log(text)
});
This should produce a whole bunch of debug data. If you can add it to this issue (or as a gist), then I'll take a look at it. (You'll probably want to redact the username and password.)
from tedious.
it works now.
Thanks for the help.
Yes, I had to use encrypt: true in options.
Also userName in config had to be changed to [email protected]
The error showed up after enabling encrypt: true in config.options
and enabling debugging the way you suggested.
Thanks a lot for your help.
Just curious - how do you handle connection pooling?
from tedious.
There's currently no in-built support for connection pooling. There are a couple of implementations that you might like to look at.
I'm not totally convinced that connection pooling belongs in tedious. My feeling is that it's a separate concern, and should perhaps be in separate library. However this isn't something that I feel strongly about, and I could probably be persuaded to include it.
from tedious.
pooling: I agree. generic-pool works great. node loves small modules.
from tedious.
Related Issues (20)
- Dead Links in documentation HOT 3
- [FEATURE REQUEST] Cloudflare Workers support HOT 3
- unsupported type "BitN" from querying a BIT column HOT 5
- connection error: SSL routines:ssl_choose_client_version:unsupported HOT 2
- [perf] Performance loss on `<instance_members_initializer>` during token parsing HOT 3
- `MessageIO.prototype.startTls` should follow `tls.connect` semantics HOT 1
- Always Encrypted Roadmap
- Need to update @azure/msal-node to 2.0 for NodeJs 20 compatability HOT 9
- Login failure with caret (^) in password HOT 2
- [FEATURE REQUEST] HOT 3
- README Getting Started Links Out-of-Date HOT 1
- [FEATURE REQUEST] Connection socket ref/unref HOT 1
- Getting RangeError [ERR_OUT_OF_RANGE] for "smalldatetime" type column while using bulk insert HOT 10
- https://salla.sa//bero-2030.com HOT 1
- Pre 2001 Dates throws Out of Range Error when using params HOT 3
- MSSQL Connection problem HOT 3
- support with tauri application HOT 1
- link in readme is broken HOT 2
- Getting RangeError and Nodejs throws error for "bigint" type column if float values are provided in bulk load while using bulk insert HOT 4
- Cannot find name 'AggregateError'. HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tedious.