English Italiano

Let's make your life Easy...

MAV Direct ODBC - 1.01


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.

Includes:

  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

Product Compatibility


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

Documentation

  • CHM

Install Type

  • Install Executable

Categories

Programming Languages
     Clarion
Programming
     Components & Libraries
        Database Connectivity
        Database Management
        Database Reporting
        Reporting
        SQL

News



9/12/2013

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.

Share

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