Neither SQL Connection nor SQL OpenNet have features that use Windows clustering (MCSC), but customers have been successfully connecting to SQL Server databases on Windows clusters. To do this, run SQL OpenNet on a single node of the cluster and do one of the following:
- Use the "Enable shared memory protocol" option for SQL Server, and specify "Network=dbmslpcn" in the connect string. (Note that this requires the VTX12_SQLNATIVE driver.)
- Specify the server machine\'s IP address or name as the server in the database_info portion of the connect string and (for SQL OpenNet connections) as the host name in the network string (opennet_info).
For information on connect string arguments, see "Building Connect Strings" in the Synergy/DE documentation.
Again, this doesn\'t provide failover support. For failover support, use SQL Server client rather than SQL OpenNet, and for SQL Server versions 2003 and above, use the VTX12_SQLNATIVE driver. Otherwise use VTX12_ODBC.
Note that tests indicate that SQL OpenNet provides better performance than connections that use the SQL Server client.