JSQLConnect

JSQLConnect 7 is fully compatible with SQL Server ’14 and takes advantage of the new features available in the Microsoft product while maintaining high performance and reliability. Version 7 continues the close working relationship between Microsoft SQL Server development and the JNetDirect programming team. In addition to compatibility with the new version of SQL Server, JSQLConnect has incorporated several new features in version 7 including: Implemented ReadOnly Intent Support AlwaysOn Availability Groups, introduced in SQL Server 2012, is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. One of its benefits is to configure a given availability replica to support Read-only connection access. "Using active secondary capabilities improves your IT efficiency and reduces cost through better resource utilization of secondary hardware. In addition, offloading read-intent applications and backup jobs to secondary replicas helps to improve performance on the primary replica." (See http://msdn.microsoft.com/en-us/library/hh510230%28v=sql.110%29.aspx for more details) Routing Support Availability Group Listeners is another new feature in SQL Server 2012. The Listeners routes incoming connections to a suitable replica.”An Availability Group Listener is a virtual network name (VNN) to which clients can connect in order to access a database in a primary or secondary replica of an AlwaysOn Availability Group. An Availability Group Listener enables a client to connect to an availability replica without knowing the name of the physical instance of SQL Server to which the client is connecting. The client connection string does not need to be modified to connect to the current location of the current primary replica.” (Seehttp://msdn.microsoft.com/en-gb/library/hh213417%28v=sql.110%29.aspx for more details)