ODBC connecting to MSSQL "Availability Group Listener"
We currently using TB 7.4.3 build 67790 and we are using the ODBC connector (SQL.ini) to our databases.
We are trying to create a SQL cluster with a "Availability Group Listener" on top.
Current configuration of the string in SQL.ini (this works fine):
remotedbname=SHFL,DRIVER=SQL Server;UID=USER;DATABASE=SHF;SERVER=SQLBox1.domain.local
SQLBox1.domain.local is a direct DNS name to one of 2 SQL boxes.
What we would need to change on the SQL string is this:
SERVER=AvailatyGroup.domain.local;MultiSubnetFailover=True
With or without the "MultiSubnetFailover=True" Gupta cannot connect yet it can connect directly to a box.
Any help would be appreciated.
Regards,
0
Categories
- All Categories
- 123 Developer Announcements
- 54 Articles
- 150 General Questions
- 148 Thrust Services
- 57 OpenText Hackathon
- 37 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 918 Core Messaging
- 84 Digital Asset Management
- 9.4K Documentum
- 32 eDOCS
- 186 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 8 XM Fax
- Follow Categories
