PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Setup
  • Configuration
  • Using the ODBC driver for HFSQL Classic or Client/Server
  • Managing OPEN FILE queries
  • Accessing HFSQL Client/Server files
  • INSERT query
  • Notes and limits
  • Deleting a driver
  • Using the most recent version of the driver
  • Access 2000
  • Note
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
ODBC driver for HFSQL Classic and for HFSQL Client/Server (Windows)
OLE DBNative AccessesNot available with these kinds of connection
Overview
The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access a HFSQL Classic database from an external database software that supports the accesses by ODBC.
The ODBC driver for HFSQL Client/Server is used to access a HFSQL Client/Server database from an external database software that supports the accesses by 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 2.
Versions 20 and later
The ODBC driver for HFSQL Classic and HFSQL Client/Server is an ODBC driver of level 3. The ODBC driver offers several additional features such as:
  • better support for the UNICODE standard,
  • support for transactions,
  • multiple bookmarks on the tables,
  • search by wildcard on the schema tables,
  • management of cursors by block.
New in version 20
The ODBC driver for HFSQL Classic and HFSQL Client/Server is an ODBC driver of level 3. The ODBC driver offers several additional features such as:
  • better support for the UNICODE standard,
  • support for transactions,
  • multiple bookmarks on the tables,
  • search by wildcard on the schema tables,
  • management of cursors by block.
The ODBC driver for HFSQL Classic and HFSQL Client/Server is an ODBC driver of level 3. The ODBC driver offers several additional features such as:
  • better support for the UNICODE standard,
  • support for transactions,
  • multiple bookmarks on the tables,
  • search by wildcard on the schema tables,
  • management of cursors by block.
See a specific documentation for more details.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 20 and later
Note: This help page explains how to install the ODBC driver for HFSQL Classic and HFSQL Client/Server for Windows. The setup of the ODBC driver for HFSQL Classic and HFSQL Client/Server for Linux is presented in the help page named ODBC driver for HFSQL Linux.
New in version 20
Note: This help page explains how to install the ODBC driver for HFSQL Classic and HFSQL Client/Server for Windows. The setup of the ODBC driver for HFSQL Classic and HFSQL Client/Server for Linux is presented in the help page named ODBC driver for HFSQL Linux.
Note: This help page explains how to install the ODBC driver for HFSQL Classic and HFSQL Client/Server for Windows. The setup of the ODBC driver for HFSQL Classic and HFSQL Client/Server for Linux is presented in the help page named ODBC driver for HFSQL Linux.
Setup
The ODBC driver for HFSQL Classic and HFSQL Client/Server can be installed when installing WINDEV or WEBDEV on the development computer.
Furthermore, when configuring the setup program of your WINDEV applications or WEBDEV sites, you have the ability to include the setup of the ODBC driver for HFSQL (Classic or Client/Server).
Notes:
  • Until version 140025, the ODBC driver was installed in the "Windows\system32" directory. From version 140026, the ODBC driver is installed in the "Program Files\Common Files\PC Soft\23.0\ODBC" directory.
  • If necessary, the setup program of the ODBC driver (WX230PACKODBC.EXE) is found in the "Install\ODBC" directory of WINDEV or WEBDEV.
Configuration

Using the ODBC driver for HFSQL Classic or Client/Server

To use the ODBC driver for HFSQL Classic or Client/Server:
  1. Start the administrator of ODBC data (ODBCAD32.EXE) on your computer. To do so, select "Start .. Run" from Windows and type "ODBCAD32.EXE".
    Note: In Windows Vista (or higher) in 64 bits, start "c:\windows\syswow64\odbcad32.exe".
  2. Select the "User database" tab.
  3. Click the "Add" button.
  4. Select the "HyperFileSQL" driver.
  5. Click "Done".
  6. Enter the name of the HFSQL data source. This name will be used to identify the HFSQL database in the external programs.
  7. Click the "Details" button.
  8. Use the browse buttons to select the WDD file corresponding to the analysis.
  9. In the list of analyses, select the requested analysis and validate.
  10. If the database is in "HFSQL Classic" format, check "HyperFileSQL Classic" and select the directory of the data files via the browse button. All the HFSQL Classic data files corresponding to the selected analysis are grouped in this directory.
    Caution: a file directory must be selected for each analysis.
    Validate ("OK" button).
    If the database is in "HFSQL Classic" format, check "HFSQL Classic" and select the directory of the data files via the browse button. All the HFSQL Classic data files corresponding to the selected analysis are grouped in this directory.
    Caution: a file directory must be selected for each analysis.
    Validate ("OK" button).
  11. If the database is in "HyperFileSQL Client/Server" format, check "HyperFileSQL Client/Server" and specify the parameters for connecting to the server:If the database is in "HFSQL Client/Server" format, check "HFSQL Client/Server" and specify the parameters for connecting to the server:
    • The address of the server,
    • The port,
    • The name of the database to use,
    • The user name used to access the database,
    • The password associated with the user. The password is stored in encrypted format.
  12. Validate ("OK" button).
The database can be used in read/write from the external programs via the ODBC driver for HFSQL Classic or Client/Server.
The string for connecting to the driver must have the following format:
DRIVER={HYPERFILESQL};Server Name=127.0.0.1;Server Port=4900;
Database=dbName;UID=username;PWD=password
The connection string to the HFSQL Classic driver must have the following format:
DRIVER={HFSQL};ANA=<Path of WDD file>;REP=<Data directory>

For example:
Driver={HFSQL};ANA=C:\My Projects\CRM\CRM.wdd;REP=C:\My Projects\CRM\Exe
The connection string to the HFSQL driver in Client/Server mode must have the following format:
DRIVER={HFSQL};Server Name=127.0.0.1;Server Port=4900;
Database=dbName;UID=username;PWD=password
Note: To use the HFSQL database with a PHP site, you must define a "system" ODBC source (rather than a "user" one).

Managing OPEN FILE queries

To use the OPEN FILE queries on HFSQL files, you must specify:
  • the PATH keyword to change the file directory.
  • the USING keyword to specify the file password.
The syntax is as follows:
OPEN FILE <File Name> [PATH <File Directory>] [USING <File Password>]
Example:
OPEN FILE Customer PATH "C:\Temp\My test" USING mypassword
Note: The file names, the directory names and the passwords can be enclosed in quotes if they contain space characters.

Accessing HFSQL Client/Server files

The OPEN FILE queries also allow you to access the HFSQL CLient/Server databases. To do so, specify:
  • the server to use via the SERVER keyword
  • the database to use via the DATABASE keyword
  • the user via the USER keyword
  • the directory of the files via the PATH keyword
Example:
OPEN FILE * SERVER TestServer DATABASE Example USER Admin PATH "MyDatabaseHFCS"
Note: The file names, the directory names and the passwords can be enclosed in quotes if they contain space characters.

INSERT query

When running an INSERT query, the SQL.IdAuto variable contains the automatic identifier that was added during the previous INSERT.
Notes and limits

Deleting a driver

When the DLLs are deleted from a driver, the data sources that use this driver must be deleted beforehand. Otherwise, the application may be locked.

Using the most recent version of the driver

To use the most recent version of a driver, you must delete the data source and re-create it by using the proposed "HyperFileSQL" driver.

Access 2000

When importing a table from an ODBC data source into Access 2000, the HFSQL Classic data source must be defined as "Computer data source" (instead of "File data source").
Versions 18 and later

Note

The ODBC driver supports the Unicode format.
New in version 18

Note

The ODBC driver supports the Unicode format.

Note

The ODBC driver supports the Unicode format.
Minimum required version
  • Version 12
This page is also available for…
Comments
ODBC DSN less Connection to HF Classic
sConnection = "Driver=HFSQL;ANA=C:\My Projects\List & Label Example - Glenn\List & Label Example.wdd;REP=C:\My Projects\List & Label Example - Glenn\Exe"

The problem ended up being how to specify the Directory for the HF files. Notice the REP parameter, DIR does not work but REP does.
Glenn
Jan. 18 2017
Declare port number
If your database is on a port other than the default port "4900" you may have to specify your port number after your IP address (step 11.a). For example 10.10.10.10:7777. Without this specification the ODBC driver may default to 4900 regardless the port declared on step 11.b
Tim FISCHBECK ( Eide
Nov. 07 2013