Connect to ReadOnly MS-SQL Server Database through tdbinput

[avinashu]

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?

[Dave_Simo]

Hello,

I don't know if it will work but try connecting with a tDBconnexion/tDBInput component in JDBC

Best Reagrds,