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
- 118 Developer Announcements
- 52 Articles
- 150 General Questions
- 137 Services
- 56 OpenText Hackathon
- 35 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 912 Cloud Fax and Notifications
- 82 Digital Asset Management
- 9.3K Documentum
- 30 eDOCS
- 175 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 6 XM Fax