anyone succeded in connecting to Azure SQL database and inserting/selecting data? I tried two nodes, but I run into problems with both.
The situation: I want to insert tons of data with INSERT command, so I call sql command like in every 3 seconds.
With node-red-contrib-azure-sql I experienced that after 50-60 calls I always run into this error message:
31 Jan 13:57:07 - Error: No event 'socketConnect' in state 'Final'
at Connection.dispatchEvent (C:\Users\Administrator.node-red\node_modules\tedious\lib\connection.js:674:28)
at Connection.socketConnect (C:\Users\Administrator.node-red\node_modules\tedious\lib\connection.js:698:19)
With node-red-contrib-mssql-plus I am not able to connect to azure sql: I always get the error message "Login failed for user 'USERNAME'.","name":"ConnectionError"
General options like username, pw, network access (firewall etc) are checked, connection is working from other client/admin programs.
Is there an SQL node what can be used especially for azure SQL server?