The Microsoft SQL Server Connectivity Kit enables DataFlex, Visual DataFlex and WebApp applications to store and retrieve data using Microsoft's SQL Server, a high performance, client/server relational database management system.

Connectivity Kits v5 Features:

Faster Performance — several changes to the design of the Connectivity Kits has rendered measurable speed improvements. Users should test the new drivers to evaluate actual performance increases with their systems, data and applications.

Improved Locking Mechanism — provides more control over Deadlocks and Timeouts.

Silent Login — a new option that allows programmatic control over invalid login information without desktop interaction for configurations where a user dialog is not needed or desired.

Redirectable Connection — allows changing an open database connection to point to a different database that is identical to the definition of the initial database connection.

Automatic Client Selection — with the introduction of SQL Server 2005, Microsoft created a new Client. It is possible for a machine to have two different SQL Server clients installed - one for SQL Server 2000 and one for SQL Server 2005. In the login logic of the new Version 5 Connectivity Kit, the correct client is automatically selected.

DataFlex Connection IDs — this new concept provides a way to give a connection string a logical identification. When specifying the connection in applications, the logical identification is used rather than the actual connection string. This allows a setup where a program uses the same set of tables in multiple databases to only have one set of intermediate files. This technique can greatly simplify deploying an application with a Client/Server database.

Support for Express Connectivity — Connectivity Kits version 5 includes Express Connectivity - a special, no-entry-cost Connectivity Kit license for deployment only with a commercial Visual DataFlex Client License and a free "Express" SQL server. Microsoft, IBM and Oracle now offer free "Express" versions of their world-class SQL servers. These high-performance, highly reliable database products are ideally suited for use with Visual DataFlex and DataFlex for Linux solutions in many small and medium sized businesses. With Express Connectivity, when small user-count Visual DataFlex and DataFlex solutions are deployed on an Express SQL server, there is no initial connectivity kit license cost. The only cost to the customer is a small increment in their next annual subscription fee. Read more about Express Connectivity.

Read What's New in Version 5 (PDF). 

When distributing the driver components you must purchase licenses for each of your deployment sites.

Subscriptions Now Available for Connectivity Kits
In addition to enhanced capabilities and performance, Data Access Worldwide's Connectivity Kits include a new policy for future updates and maintenance. In conformance with other Data Access Worldwide products, all Connectivity Kits include a one-year "subscription" at no additional cost.

For more information on pricing and licensing please contact Sales@DataAccess.com.

Download the latest Connectivity Kit from our ftp site, and install it for a 60 day evaluation.

You may also connect to the Data Connectivity Web Forum for the latest information on the Connectivity Kits at http://Support.DataAccess.com/Forums.