FlexTools

The new home for QODBC and FlexODBC

FlexODBC - ODBC Driver for the DataFlex® Embedded DBMS

FlexODBC is a 32bit ODBC driver (DLL) for the DataFlex Embedded DBMS. Visual DataFlex and Character Mode DataFlex stores its data in its own proprietary indexed DBMS file format. This driver allows users of any ODBC compliant front end application to read and write data contained in DataFlex format files similarly to any other ODBC enabled database.

FlexODBC works by accepting SQL commands through the ODBC interface, then converting those calls to navigational commands to the DataFlex DBMS and returning record sets that qualify for the query results. This driver is not a Client/Server product, and navigates the data files directly.


What can I do with FlexODBC?
FlexODBC opens up the DataFlex files created by thousands of custom programs to the new world of database connectivity. In the same way that Windows has created an environment where all applications have a similar look and feel, ODBC drivers make all database formats look the same.

A user in Microsoft Office can use Excel to pull company accounting or invoice information directly into a spreadsheet and create a chart. Microsoft Word can do a customer mail merge directly from DataFlex files. Crystal Reports users can create multi-file reports from DataFlex data. Microsoft Access or Borland Delphi can be used to merge DataFlex data with other data sources to produce complex reports, or to run mass file updates based on multiple criteria.


New Features in Version 4
FlexODBC 4.0 now utilizes the new Data Access v2.1 API and supports DataFlex versions 2.3b right thru to DataFlex 2014 (v18).

Our goal with this release was to make it easy to evaluate, cheaper to purchase, easy to order, easy to install and easy to use, and we now no longer count concurrent users so you will never have "Maximum Number of Users Exceeded" errors anymore!!!

Along with this new release also comes many new changes, from its functionality and looks to the way it is registered and sold now. Besides the ability to handle the extended filelist.cfg (4096 files) and new file header format, FlexODBC 4.0 supports driver based databases such as Pervasive.SQL, Microsoft SQL Server, etc.

In other words, applications using FlexODBC can now continue to work when the back end database is migrated from the DataFlex Embedded DBMS to server environments, like MS SQL Server, without any changes. FlexODBC v4 just needs to be able to locate the .int files and a licensed Data Access Connectivity Kit for MS SQL driver (for this given example).


You can also now speed up combo boxes in applications by limiting the number of rows returned from a SQL query by using TOP, for example:


SELECT TOP 20 * FROM customer


retrieves only the first 20 customers and not every customer in the table.


Other Key Features

  • ODBC Data Source Administrator Version 3.0 compliant
  • ODBC Level 2 compliant - allows the use of MS ADO 2.1 & MS SQL 7/2000
  • Windows XP Professional O/S Support
  • between() operator
  • add/drop indexed, reindex
  • grant/revoke security rights to the table level
  • faster performance
  • outer join support
  • Nested sub-selects & "exists", for example

SELECT * FROM EMPLOYEE
     WHERE NAME IN (SELECT NAME FROM EMPLOYEE)

SELECT OWNERFIRSTNAME, OWNERLASTNAME
     FROM ANTIQUEOWNERS
     WHERE EXISTS (SELECT * FROM ANTIQUES WHERE ITEM = 'Chair')


This is a list of all of the SQL functions now supported in Release 4:-

FlexODBC String Functions

ASCII(string_exp)
CHAR(code)
CONCAT(string_exp1, string_exp2)
DIFFERENCE(string_exp1, string_exp2)
INSERT(string_exp1, start, length, string_exp2)
LCASE(string_exp)
LEFT(string_exp, count)
LENGTH(string_exp)
LOCATE(string_exp1, string_exp2[, start])
LTRIM(string_exp)
REPEAT(string_exp, count)
RIGHT(string_exp, count)
RTRIM(string_exp)
SOUNDEX(string_exp) - Returns a character string representing the sound of the words in string_exp.
SPACE(count)
SUBSTRING(string_exp, start, length)
UCASE(string_exp)

FlexODBC Numeric Functions

ABS(numeric_exp)
ACOS(float_exp)
ASIN(float_exp)
ATAN(float_exp)
ATAN2(float_exp1, float_exp2)
CEILING(numeric_exp)
COS(float_exp)
COT(float_exp)
DEGREES(numeric_exp)
EXP(float_exp)
FLOOR(numeric_exp)
LOG(float_exp)
LOG10(float_exp)
MOD(integer_exp1, integer_exp2)
PI()
POWER(numeric_exp, integer_exp)
RADIANS(numeric_exp)
RAND([integer_exp])
ROUND(numeric_exp, integer_exp)
SIGN(numeric_exp)
SIN(float_exp)
SQRT(float_exp)
TAN(float_exp)
TRUNCATE(numeric_exp, integer_exp)


FlexODBC Time and Date Functions

CURDATE()
CURTIME()
DAYNAME(date_exp)
DAYOFMONTH(date_exp)
DAYOFWEEK(date_exp)
DAYOFYEAR(date_exp)
HOUR(time_exp)
MINUTE(time_exp)
MONTH(date_exp)
MONTHNAME(date_exp)
NOW()
QUARTER(date_exp)
SECOND(time_exp)
TIMESTAMPADD(interval, integer_exp, timestamp_exp)
TIMESTAMPDIFF(interval, timestamp_exp1, timestamp_exp2)
WEEK(date_exp)
YEAR(date_exp)


FlexODBC System Functions

DATABASE()
IFNULL(exp, value)
USER()


Functions use the following {fn functionname(parameters)} syntax, for example:

SELECT {fn LEFT("Name", 5)} AS "Left 5", "Name" FROM Customer


What is ODBC?
ODBC (Open DataBase Connectivity) is a specification designed by Microsoft to allow Windows applications to access multiple data sources through a single method with no regard for various file formats. SQL (Structured Query Language) is used as the method for accessing data through ODBC. Vendors of ODBC drivers (like this one) follow the specifications for ODBC so that any ODBC compliant application can access the data available through the driver. ODBC compliant applications include: Microsoft Access, Word, Excel, Powerbuilder, Borland Delphi, Crystal Reports XI (Professional, Developer and Server Editions), Visual Basic and hundreds of others.


FlexODBC Evaluation Version
The evaluation edition of the FlexODBC driver will only operate for a period of 30 days, beyond which it will fail. This does not affect registered users. Should your evaluation copy expire, you need to purchase a FlexODBC CDKey Code.


How does the evaluation copy work?
If the product is unregistered, it is limited to 100 records searched per query in evaluation mode. If a query returns no result, it may be that no match was found within the first 100 records. Try a more simple query instead.


System Requirements:
Minimum CPU required: Pentium II processor 450 MHz or better
Minimum memory required: 64 MB
Minimum hard disk space required: 30 MB
Operating system version: Windows 98SE/2000/ME/NT 4.0/XP/Windows 7/8/8.1
DataFlex version 2.3b or higher (includes DataFlex 2014)