Azure SQL: what node to use?

General
1

Hi,

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?

2

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.