English Italiano

Let's make your life Easy...

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




  OF 0

  OF 33







loc_Select     MAVSelect


 Loc_Select.Init(,0) ! read all


 IF loc_Select.Run()





  IF loc_Select.Fetch()

   IF ERRORCODE() ~= 35







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


  1. Library version.
  2. Template version (full clone of the standard templates (with some extra) for easy work with the library).

http://Download Trial/Demo  Downloads: 1482

Operating System for Deployment

  • Windows 2000
  • Windows 7
  • Windows 8
  • Windows 98
  • Windows Server 2003 x64
  • Windows Vista Business
  • Windows Vista Enterprise
  • Windows Vista Home Basic
  • Windows Vista Home Premium
  • Windows Vista Starter
  • Windows Vista Ultimate
  • Windows Vista Ultimate x64
  • Windows XP

Architecture of Product

  • 32Bit

Product Type

  • Add-In

Component Type

  • DLL
  • LIB
  • Template ABC
  • Template Legacy

Compatible Containers

  • Microsoft SQL Server 2000
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 7.0
  • Oracle Database 10g
  • Oracle Database 11g
  • Oracle Database 7.x
  • Oracle Database 8.x
  • Oracle Database 8i
  • Oracle Database 9i
  • SoftVelocity Clarion 5.0
  • SoftVelocity Clarion 5.5
  • SoftVelocity Clarion 6.3
  • SoftVelocity Clarion 7.3
  • SoftVelocity Clarion 8.0
  • SoftVelocity Clarion 9.0


  • CHM

Install Type

  • Install Executable


Programming Languages
     Components & Libraries
        Database Connectivity
        Database Management
        Database Reporting


MAV Direct ODBC ver 1.01 for Clarion 9 now available!

Libraries were recompiled for C9.  Clarion9 aware setup file is available. And known bugs fixed.

This release is available, free of charge, to all customers who have an active maintenance and support subscription plan.

About product

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 from Clarion application.


Buy Now!

IngasoftPlus's products are available at www.motleysoft.com - the world softfair! No records

Download Information

The following downloads are available for this products:
No Downloads
Go To Download

Product Search