node-red-contrib-mssql-plus
node-red-contrib-mssql-plus copied to clipboard
bestlong
A Node-RED node to read and write to Microsoft MS SQL Databases
When I look at the package.json on NPM, it says: "engines": { "node": ">=12.0.0" That same line on v12.2 on github says "engines": { "node": ">=16" I don't see in...
Hi, it is not specified in the user document what is the authenitcation method. I need to connect to Dynamics 365 MSSQL DB. Currently I can access Dynamics 365 DB...
About 5 years ago I created a flow with various nodes, including some nodes with SQL. Over time, I updated nodeJS, Node-Red etc. **Most of the SQL nodes are unchanged...
The package.json file expects to see a version of node >=12. A previous bug report I filed stated that the version of Node I was using (version 16) was deprecated...
The current module only seems to support password authentication with Azure SQL . Are there any plans to support other authentication methods ? AD Password ?
Context: I am using version 0.4.4 I got this error: "Cannot read property 'on' of undefined" and restarting the flow has solved it. But over time (maybe months or even...
### Current Behavior Node-red crashed with this dump (while deploying) 20 Dec 16:57:05 - [red] Uncaught Exception: 20 Dec 16:57:05 - [error] ConnectionError: Cannot close a pool while it is...
Node red crashed because of the following error. Please make sure that node-red does not crash in this case. RequestError: Transaction (Process ID 84) was deadlocked on lock resources with...
When returning epoch dates out of MSSQL we need to use DATEDIFF function: in a query, using the T-SQL function DATEDIFF(SECOND,'1970-01-01',getdate()) returns an int and this is correctly returned as...
Version 0.10.2 will not install with nodejs 20.4.0 on Ubuntu 20.04. The dependency @azure/msal-node requires nodejs 10,12,14,16 or 18. The error when attempting to install is ``` ~/.node-red$ npm install...
