|
|
|
|
- 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
ODBC driver for HFSQL Classic and for HFSQL Client/Server (Linux)
Not available with these kinds of connection
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.
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: 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
- 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>
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|