PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
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
Server (Property)
In french: Serveur
ODBCHFSQLNot available with these kinds of connection
The Property Server allows to manage the data source of a connection (HFSQL Client/Server, OLE DB, ...). You can:
  • Find out the data source used for a connection (HFSQL Client/Server, OLE DB, ...).
  • Define the data source used for the connection (HFSQL Client/Server, OLE DB, ...). In this case, if the connection is currently opened, it will be closed and reopened with the new parameters during the first access to a file that uses this connection.
Caution: if you are using a remote database and if you are using an Internet connection to access it, the entry port of the router must be redirected onto the HFSQL server. For more details, see Managing ports.
Remark: The connection can correspond to:
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
MyConnection is Connection
// Describe the connection
MyConnection.User = "USER"
MyConnection.Password = "PASSWORD"
MyConnection.Server = "MYSERVER"
MyConnection.Database = "Database"
MyConnection.Provider = hAccessHFClientServer
MyConnection.Access = hOReadWrite
MyConnection.ExtendedInfo = "Extended information"
MyConnection.CursorOptions = hClientCursor
 
HOpenConnection(MyConnection)
Syntax

Finding out the data source of the connection Hide the details

<Data source> = <Connection used>.Server
<Data source>: Character string
  • Name of the server (for HFSQL Client/Server, SQL Server, Oracle, MySQL, etc.)
  • Name of the file used as data source (for Access, XML, xBase, etc.)
<Connection used>: Character string (with or without quotes) or Connection variable
Name of connection used. This name was defined:

Defining the data source of the connection Hide the details

<Connection used>.Server = <Data source>
<Connection used>: Character string (with or without quotes) or Connection variable
Name of connection used. This name was defined:
<Data source>: Character string
  • Name or IP address of the server (for HFSQL Client/Server, SQL Server, Oracle, MySQL, ...)
  • Name of the file used as data source (for Access, XML, xBase, etc.)
Remarks
The Property Server is equivalent to the Property Source.
These two properties are kept to make the code easier to understand. Indeed, when connecting HFSQL Client/Server, SQL Server, Oracle, MySQL, the Server property is recommended because it is necessary to indicate a server name.
On the contrary, Source should be used with the connections (Access, XML or xBase) for which a file name must be specified.
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment