Possible to include connection option for ApplicationIntent?

bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases

MIT License

31 stars 18 forks source link

Possible to include connection option for ApplicationIntent? #61

Closed am-rpa closed 8 months ago

am-rpa commented 2 years ago

At first glance I don't see the ability to define the ApplicationIntent. This is needed for Availability Groups with read-only replicas. The connection string value would be "ApplicationIntent=ReadOnly". I don't mind working on a PR as I believe this is supported in Tedious, but want to make sure I'm not overlooking the ability to do this currently.

Steve-Mcl commented 2 years ago

Hi, if you are willing to do PR that would be great.

I suspect you need to add readOnlyIntent: to the options object (and set it's value from a new option in the config node)

bestlong commented 2 years ago

https://github.com/tediousjs/node-mssql/issues/400