PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Setup
  • Configuration
  • Using the analysis in a connection to a HFSQL Classic database
  • Notes
  • Examples of OLE DB connection strings
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
Overview
The OLE DB provider for HFSQL is used to access a HFSQL database (Classic or Client/Server) from an external software that manages the accesses by OLE DB.
The provider is available in read/write mode. An application written in external language can read and write in HFSQL files.
See a specific documentation about OLE DB for more details.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Setup
The OLE DB provider for HFSQL is supplied as a setup pack available in the "Install\OLEDB" directory of WINDEV and WEBDEV.
By default, the OLE DB provider is installed in the "C:\Program Files\Common files\PC SOFT\23.0\OLEDB".
Note: In order for an application to use an OLE DB provider, the MDAC component (Microsoft Data Access Component) version 2.8 or later must be installed. This component can be downloaded from the Microsoft site. It is included in the operating system from Windows 2003 Server and Windows Vista.
Configuration
The application that is using an OLEDB provider must provide a connection string. This string defines the provider to use as well as the connection parameters that must be given to this provider to establish the connection to the database.
This string (called connection string) can be:
  • entered in programming (in an application in C# or VB.Net for example).
  • built via a wizard (with Crystal Report for example).
The format of the connection string is as follows:
<Element1>=<Value1>;<Element2>=<Value2>;...;<ElementN>=<ValueN>
The elements of the connection string are as follows:
ElementValue during a connection to a HFSQL Client/Server databaseValue during a connection to a HFSQL Classic database
ProviderThis element is always set to "PCSOFT.HFSQL"
Data SourceName (or IP address) of the HFSQL server and connection port.
The port may not be specified if the server is using the default port (4900).
The name and the port number must be separated by ":" (colon).

Example: myserver.mycompany.fr:4910
Full path of the analysis file (.WDD file) of the database.
This parameter is optional.
Initial CatalogDatabase name.Full path of the directory containing the data files.
User IDUser name to connect to the HFSQL server.This parameter is ignored.
PasswordPassword to connect to the HFSQL server.This parameter is ignored.
Extended PropertiesCharacter string containing the properties specific to the OLE DB provider for HFSQL.
This string has the following format:
<Property1>=<Value1>;<Property2>=<Value2>;...;<PropertyN>=<ValueN>

The \ (backslash), = (equal sign), ; (semicolon) or: (colon) characters used in this string must be preceded by \ (backslash).
The properties available for the "Extended Properties" element of the OLE DB connection string are as follows:
PropertyValue
PasswordPassword of the HFSQL data files in the following format:
<FileName>:<Password>
Notes:
  • <FileName> represents the logical name of the data file.
  • <FileName> can be replaced by "*" (star) to specify that the password is applied to all the data files.
  • This property can be repeated to specify the passwords of several data files.
    Example: Password=MyFile1:Password1;Password=MyFile2:Password2
LanguageLanguage used by the OLE DB provider for HFSQL to process the string (sort, ...).
The values correspond to the constants of ChangeCharset.
The available values are:
Property valueCorresponding WLanguage constant
UTF-8charsetUTF8
ISO-8859-1 or ISO-LATIN-1charsetOccidental
ISO-8859-2 or ISO-LATIN-2charsetEastEurope
ISO-8859-3charsetTurkish
ISO-8859-4charsetBaltic
ISO-8859-5 or KOI8-RcharsetRussian
ISO-8859-6charsetArabic
ISO-8859-7charsetGreek
ISO-8859-8charsetHebrew
ISO-2022-JPcharsetJapanese
GB-2312charsetChinese
VISCIIcharsetVietnamese
BIG5charsetTraditionalChinese
ISO-2022-KRcharsetKorean
ISO-8859-11charsetThai

Using the analysis in a connection to a HFSQL Classic database

For a connection to a HFSQL Classic database:
  • If the path of the WDD file is specified in the "Data Source" parameter of the connection string:
    • Only the files described in this analysis will be taken into account by the connection.
    • The links and the integrity rules described in the analysis are automatically taken into account.
  • If the path of the WDD file is not specified in the "Data Source" parameter of the connection string:
    • All the files found in the directory specified in the "Initial Catalog" parameter will be taken into account.
    • No integrity constraint is automatically respected between the files.

Notes

  • During an access by the OLE DB provider for HFSQL, the automatic assistance windows of HFSQL are disabled.
  • The "Duration" items found in the HFSQL data files are returned as 8-byte integers by the OLE DB provider. The unit is the millisecond.
  • The array items are not supported by the OLE DB provider.
  • The SQL commands with parameters are not supported in this version.
    Versions 17 and later
    The queries with parameters are supported. This allows you to add HFSQL memos (binary memo for example).
    New in version 17
    The queries with parameters are supported. This allows you to add HFSQL memos (binary memo for example).
    The queries with parameters are supported. This allows you to add HFSQL memos (binary memo for example).

Examples of OLE DB connection strings

  • Connection to a HFSQL Classic database without specifying the analysis:
    Provider=PCSOFT.HFSQL;Initial Catalog=c:\My HFSQL Database
  • Connection to a HFSQL Classic database and specifying the analysis:
    Provider=PCSOFT.HFSQL;Data Source=c:\My HFSQL Database\MyAnalysis.wdd;
    Initial Catalog=c:\My HFSQL Database
  • Connection to a HFSQL Client/Server database:
    Provider=PCSOFT.HFSQL;Data Source=serverdb.mycompany.fr:4910;
    User ID=admin;Password=secret;Initial Catalog=MyDatabase
  • Connection to a HFQL Client/Server database with password-protected files that is using the Russian character set:
    Provider=PCSOFT.HFSQL;Data Source=serverdb.mycompany.fr;
    User ID=user;Initial Catalog=MyRussianDatabase;
    Extended Properties="Password=*:secret1;
    Password=Fichier2:secret2;Language=KOI8-R"

    Note: In this example, all the database files are protected by the "secret1" password except for the "File2" file that is protected by the "secret2" password.
Minimum required version
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment