I'm trying to connect to the ReadOnly instance of an MS-SQL Server database using tdbinput, and I've set the "Additional JDBC Parameters" in the advanced settings to "ApplicationIntent=ReadOnly". However, when I check the query output, it still shows that it's connecting to the READ_WRITE instance.
I tested the same connection with "ApplicationIntent=ReadOnly" in SSMS, and it worked fine, showing that I was connected to the READ_ONLY instance.
Has anyone encountered a similar issue or can suggest a solution for connecting to the ReadOnly instance using tdbinput?
Hello,
I don't know if it will work but try connecting with a tDBconnexion/tDBInput component in JDBC
Best Reagrds,
