ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / Access via ODBC or OLE DB
  • Overview
  • Setup
  • Prerequisite: installing the iODBC manager
  • Installing the driver
  • Configuring the database
  • Overview
  • Configuring a data source via the graphic tool of iODBC
  • Manual configuration
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
ODBC driver for HFSQL Classic and for HFSQL Client/Server (Linux)
OLE DBNative Connectors (Native Accesses)Not available with these kinds of connection
Overview
The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC.
The ODBC driver for HFSQL Client/Server allows access to an HFSQL Client/Server database from an external database software that supports access via ODBC.
The driver is available in read/write. An application written in external language can read and write in HFSQL files.
The ODBC driver for HFSQL Classic and HFSQL Client/Server is an ODBC driver of level 3. See a specific documentation for more details.
Remarks:
  • This help page explains how to install the ODBC driver for HFSQL Classic and HFSQL Client/Server for Linux. The setup of the ODBC driver for HFSQL Classic and HFSQL Client/Server for Windows is presented in the ODBC driver for HFSQL Classic and for HFSQL Client/Server page.
  • To give access to the HFSQL data via the ODBC driver, the ODBC driver for Linux must be installed manually on the computer where the HFSQL data is installed.
Setup

Prerequisite: installing the iODBC manager

The ODBC driver in Linux uses the iODBC manager (http://www.iodbc.org/). This program must be installed before using the driver.
To install this driver on Ubuntu, all you have to do is install the libiodbc-dev package:
apt-get install libiodbc2-dev
apt-get install iodbc

Installing the driver

The ODBC driver on Linux is supplied in 32-bit and 64-bit versions in the "INSTALL\ODBC" directory of setup directory of WINDEV, WEBDEV or WINDEV Mobile:
  • In 32-bit: wxpackodbclinux32.zip
  • In 64-bit: wxpackodbclinux64.zip
To install it:
  • Unzip the requested pack int a local directory ("/opt/wdhfo" for example).
  • Run the "install.sh" script as follows:
    >cd /path/to/driver/
    >sudo ./install.sh
Remark: This script registers the driver beside iODBC. For more details, use:
install.sh -help
Configuring the database

Overview

Two methods can be used to configure a data source:

Configuring a data source via the graphic tool of iODBC

  • Start the "iodbcadm-gtk" tool.
  • The following window appears:
  • Click "Add".
  • In the list that is displayed, select the HFSQL driver and click "Finish". The following window appears:
  • Enter the keys manually:
    • For an ISAM connection:
      • FileDir: Directory of .FIC files
      • Analysis: path of WDD. This parameter is optional
    • For a Client/Server connection:
      • Server Name: Name of server
      • Server Port: Port to use
      • Database: Name of database
      • UID: User name
      • PWD: User password
      • Analysis: path of WDD. This parameter is optional.
        Example for an ISAM connection
        Example for an ISAM connection
  • Validate the dialog twice.
The source is configured. You can run its test it with the "iodbctest" program.
iodbctest "DSN=MyODBCSource"

Manual configuration

  • Create an ".odbc.ini" file at the root of the "home" directory.
  • For each source, add the following lines into this file:
    • ISAM HFSQL source:
      [ODBC Data Sources]
      <Source Name> = HFSQL
      [<Source Name>]
      Driver = /path/vers/WD220hfo64.so
      FileDir = <path of files>
    • HFSQL C/S source:
      [ODBC Data Sources]
      <Source Name> = HFSQL
      [<Source Name>]
      Server Name = <Name of server>
      Server Port = <Port to use>
      Database = <Name of database>
      UID = <Name of user>
      PWD = <Password of user>
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 11/22/2022

Send a report | Local help