| Products | Minisoft News | Events | Downloads | Product Manuals
ODBC for Image  \  ODBC for Eloquence  \  ODBC for Unix
  News

Minisoft News

Is your company legally licensed?

Press Release:
Minisoft Releases PCI Compliant Versions of ODBC, JDBC, and OLE DB


Demo and Updates

Download an Evaluation today!

ODBC Updates


Documentation

Installing the ODBC Upgrade

Release Notes

ODBC Manual

Get Acrobat

Product Review

ODBC Product Comparison

Case Study -
QSS and Minisoft

Brochure -
"Minisoft PCI Compliant"

Customer Feedback

Latest Reviews

Product FAQ

Support FAQ

Checking Versions


ODBC Application Samples

ODBC Downloadable Utilities


ODBC for UNIX

ODBC for Eloquence

ODBC on OSX

JDBC


MSJOB Information

 
   



Using Esperant With Minisoft's 32-bit
ODBC Driver

This document will provide the first steps to producing an ad-hoc report from data on your HP e3000. Esperant is logically divided into two sections, the Administration System and the Query System. The Administration System is used to define the Data Views used in Esperant. The Query System allows you to define the various report layouts based upon the available. You will need to Data Views.

Using Esperant Administration System

Begin an Administration System session and select New from the file menu. You will be given the New Esperant Data View dialog box.

  1. Select the Autobuild Wizard.

 

  1. Provide a new name for your Data View. Select Next.

    esperant2.gif (22382 bytes)

 

  1. For this sample accept the default values. Select Next.

 

  1. If an Available Connection for your Data Source is not listed Select the Add button. Otherwise, skip to number eight (8).

    esperant4.gif (14782 bytes)

 

  1. Enter a new Connection Name. Select OK.

 

  1. Choose the Connection Type, ODBC.  Select OK.

 

  1. From the Data Source Name list, pick your Data Source Name
    Pick Minisoft ODBC from the list of available DBMS Types.  If Minisoft ODBC does not appear in the list, a few short steps can add it.
    Select OK.

    Choose a Data Source

 

  1. An Available Connection for your Data Source is now listed. Select this entry. Select Next.

    esperant8.gif (15459 bytes)

 

  1. For this sample accept the default values. Select Next.

 

  1. Select the table you wish to use and press the greater- than (>) button. 
    Select Next.

 

  1. Select Finish.  Your Data View should now be displayed with the list of items in the selected table. Exit from the Administration System and proceed to the Query System.

    esperant11.gif (16498 bytes)

 

Using Esperant Query System

  1. Start a Query System session and create a new report/query.  Select the Data View you created in the Administration System.  Select OK.

    esperant12.gif (10525 bytes)

 

  1. Show the Show Query Wizard. 

 

  1. Press the double greater- than (>>) button to select all the fields in your table. Select the Run button to start the query.

    esperant14.gif (24082 bytes)

 

  1. After the query is complete, you should see the first rows from the table.

    esperant15.gif (24702 bytes)

Note that this sample will select ALL the records from your table. If the table is large, please use the For tab on the Show Query Expertdialog box to reduce the size of the result set. 


Adding Minisoft ODBC to the DBMS Type list.

  1. Navigate to www.Minisoft.com.  Under Client Server and Web Development Tools select ODBC.  Under Reporting Tools select Speedware's Esperant, then scroll down to Adding Minisoft ODBC to the DBMS Type list.
      

  2. Download (right mouse, save as) the edbmini.ini file into your "c:\Program Files\ESPERANT\BIN32\DBMS" directory.
      

  3. From your "c:\Program Files\ESPERANT\BIN32\DBMS" directory, open and edit DBMS.INI to include:

    [DBMS##]
    Name=edbmini.ini

    Note:  Where ## is use an unused number.

  4. Restart the Esperant Administration System.