
Contributor
2024-12-24
01:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Connect to ReadOnly MS-SQL Server Database through tdbinput
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?
1 Reply

Creator
2024-12-24
06:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
I don't know if it will work but try connecting with a tDBconnexion/tDBInput component in JDBC
Best Reagrds,
130 Views
