The ODBC Connectivity Kit is used to access ODBC databases from DataFlex and Visual DataFlex programs. ODBC (Open DataBase Connectivity) is an industry standard that allows programs to access multiple database types without the need to rewrite the code for the program or having to re-link the program.
A wide variety of database management systems can be accessed through ODBC. These include enterprise database systems such as Oracle, Sybase, SQL Server, flat file systems as dBase, Paradox and even non database systems as Excel and ASCII. Many existing DataFlex applications, without change, will be able to use these non-DataFlex database systems.
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.
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.
Read What's New in Version 5 (PDF).
What's New in Revision 4.1
Revision 4.1 of the ODBC CK delivers better performance, stability and support for the ODBC standard. This latest revision also includes many enhancements and fixes, including support for Record Identity Hiding for developing database independent software, Server Side Restructuring for faster copy operations when a table definition is changed, Structure_End Rollback Support that enables rollback of changes made to the database definition if a failure occurs, a new Record Identity Method attribute that replaces the old Primary_Index_Trigger setting, case insensitive indexes, support for read only columns, and much more!
Download the latest ODBC 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.
Licenses that enable the Embedded SQL capability require the purchase of a license for each deployment sites. There is an Unlimited Distribution License (without Embedded SQL) that allows unlimited distribution of the driver with the developer's application. For pricing and licensing information please contact Sales@DataAccess.com.