TopSpeed ODBC Driver

Access TopSpeed Databases Using Database Query and Reporting Tools topspeed odbc driver topspeed odbc driver

SoftVelocity has just released an updated ODBC driver for accessing TopSpeed (.TPS) data files. This release offers major enhancements to the supported SQL syntax and conforms to the ODBC 1 specification with many Level 2 features. The TopSpeed ODBC driver allows you and your customers to use popular productivity tools including Crystal Reports and Microsoft Excel to connect to TopSpeed databases, Topspeed, Odbc Driver, Tps ODBC.

What else can the new driver do? Well, in addition to making your Clarion applications play nice with other software tools like the Microsoft Office suite, it can make your development a bit easier and your applications more flexible.Want more technical details? The new driver supports the ODBC Level 2 API (most of it). It has support for the SQL statements: GROUP BY, HAVING, AVG, COUNT, MAX, MIN, SUM. It supports left outer joins, nested sub-selects, scrollable cursors, multilevel outer joins and scalar functions. TopSpeed ODBC Driver Enhancements in version 5.0

Version 5 delivers new functionality and improvements in key areas.

TopSpeed ODBC Driver Release 5.0 features improvements in performance and more reliable connectivity with external tools such as . Microsoft Data Transformation Service (DTS), Microsoft Access and Excel. Version 5 is also compatible with the ADOdb Database Abstraction Library for PHP.

SQLStatistics now returns information for all keys and indexes, not just the primary key Driver improved performance when working wih large Strings and Decimals Wild cards can be used in the Extensions configuration option MS Access sends invalid information to SQLColumns if a table name has an _ character in it, the driver now detects this invalid information and transforms it into what Access should have passed Catalog functions will accept table names that are in quotes Added “Use ‘_’ as seperator for the extension” option to work around bug in Access / DTS where it cannot handle tables that have a . or /& in them ULONG fields can be treated as DATE or TIME fields Improved performance when reading MEMO and BLOB fields The driver supports the szTableType parameter of SQLTables The driver returns the correct scale of a decimal field even if the field definition is less than 0.1 The driver returns results for DISTINCT of more than one column in the SELECT list A File level DSN that points at a single file used to refer to that file as UNNAMED. You can now refer to the file as UNNAMED or by the physical file name

TopSpeed ODBC Driver Enhancements in verison 4.0

More efficient threading system based on the Clarion 6 core Improved support for SQL syntax INNER is now optional and assumed if you just do JOIN. This conforms to the SQL 92 spec Added support for JOIN syntax without the oj Increased the 255 character limit on string literals to 15000 BLOBs over 16 mb can now be stored and accessed Updated to work with office XP Improvement: SQLTables returns the list of table, catalog, or schema names, and table types, referenced by the data source. The driver now handles special cases of mixed superfiles and varied physical file extensions correctly.

TopSpeed ODBC Driver Download Now TopSpeed ODBC Driver For More Information Please Visit : http://www.clariondevtools.com