Home   |   MAV Direct ODBC   |   MAV direct ODBC Template version
MAV Direct ODBC


MAV direct ODBC (MAV) class and template is a set of classes and templates for quick, easy and powerful access to SQL servers using ODBC API.

Benefit of using MAV direct ODBC (MAV) class and template:

Use of ODBC 3 opportunities has allowed to increase speeds of data exchange repeatedly.
DRIVER-less approach of development (don't need to pay the money for SQL accelerators).
Development remained the same - Application & Dictionary.
Flexibility of the SQL queries creation, there is no stiff binding to the dictionary file RECORD structure.
Getting data from the tables not described in the dictionary.
Full-function working with the DATETIME fields (BETWEEN construction etc), NULL fields, SP (stored procedures).
The Constructors of the SQL queries.
Say NO to "File Already Open" error !
Getting data and putting it in any buffers, it is not required to describe any Alias in the dictionary.
Connection - does not require making the source of ODBC (DNS).
Work with any SQL server for which there is corresponding ODBC driver.
Trace the library working with the Trace utility (similar to Trace Database Driver utility from Clarion).
Multi connections - simultaneous work with the several SQL servers.
Support of multi connections for the same file from the dictionary.
Support of BLOB fields.
Support of ODBC cursors or several active cursors per connection.
and much more!

We reviewed the 3rd party products which distribute software for Clarion + SQL, i.e. templates, libraries, classes, but all of them utilize "FILE, DRIVER" technology, and no matter how they tried to optimize the templates, it was still impossible to overcome the limitations and inherent errors of the driver.

Toolkit for creation of the client-server based applications in Clarion environment.

The basic idea behind the creation of the given product was total rejection of the "FILE, DRIVER" technology during development of programs. A unique access library was written. Nothing has changed from the developer's view point, the Application and Dictionary are still present, but the product generates a totally different code (.CLW), namely there are no files but there are type groups - file prototypes.

As it was mentioned in the foreword the process of connection has become more flexible and customized. ODBC block cursors are used for data acquisition from the server instead of the non-block ones.

Simple tests have shown an enormous gain in access speed:
! === Clarion technology
! === MAV technology
SET(File)
LOOP
  NEXT(File)
 CASE ERRORCODE()
  OF 0
  OF 33
    BREAK
  ELSE
    MESSAGE(ERROR())
    BREAK
 END
END
loc_Select     MAVSelect
     CODE
 Loc_Select.Init(,0) ! read all
 Loc_Select.BindFields(File,File)
 IF loc_Select.Run()
   SQLERROR
   RETURN
 END
 LOOP
  IF loc_Select.Fetch()
   IF ERRORCODE() ~= 35
     SQLERROR
   END
   BREAK
  END
 END

The tests show an increase for MSSQL server in 10 to 35 times and for Oracle server in 6 to 10 times.

There will be 2 products available:
1. Library version.
2. Template version (full clone of the standard templates (some extra) for easy work with the library). This is just a template, library is not included.

To use MAV direct ODBC you need:
- Clarion 5b, Clarion 55 or Clarion 6.1, 6.2, 6.3 (even PE, not just EE version !!)
- ODBC driver for your SQL server
- 32-bits only

The MAV direct ODBC (MAV) was tested with the following SQL servers:
SQL server
Developers site URL
SQL Server 7, SQL Server 2000
Oracle 7, 8 server
Cache' server
mySQL server
Pervasive SQL 7, 2000 server
Firebird 1.5
Sybase Adaptive Server Anywhere 6.0
Ingres r3 GA

You may try it yourself by using our DEMO application for Library version or DEMO application for Template version. Now supports MSSQL, ORACLE, mySQL, Cache', Pervasive, Firebird, Sybase and MAV Direct ODBC! After Log On you can Generate, Browse and Execute SQL commands and view statistics. Also available a mavtrace.exe to trace MAV direct ODBC.

Download this MAV Direct ODBC benchmark program. So you can test performance of  MAV against other standard Clarion SQL drivers.


Prices:
During beta testing:
1. Library version  - $99
2. Template - $99



When it goes Gold:
1. Library version  - $249
2. Template - $149

FREE upgrade for beta testers when it turns into Gold. If you want to be a tester please send us an e-mail message (please indicate the Clarion version and the SQL driver you use). We will inform you when the beta version is out.