ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
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
Server (Property)
In french: Serveur
ODBCHFSQL ClassicNot available with these kinds of connection
The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.). 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:
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 or Connection variable
Name of the 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 or Connection variable
Name of the 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 Server and Source properties are equivalent.
These two properties are kept to make the code easier to understand. In the HFSQL Client/Server, SQL Server, Oracle or MySQL connection, the Server property is recommended because it is necessary to specify a server name.
However, in an Access, XML or xBase connection, it is recommended to use the Source property because it is necessary to specify a data file.
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help