PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

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
..Server is used 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 re-opened with the new parameters during the first access to a file that is using 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. See Managing ports for more details.
Note: The connection can correspond to:
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store Apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
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 name>..Server
<Data source>: Character string
  • Name of the server (for HFSQL Client/Server, SQL Server, Oracle, MySQL, ...)
  • Name of the file used as data source (for Access, XML, xBase, ...)
<Connection name>: Character string (with or without quotes)
Name of connection used. This name was defined:

Defining the data source of the connection Hide the details

<Connection name>..Server = <Data source>
<Connection name>: Character string (with or without quotes)
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, ...)
Remarks
..Server is equivalent to ..Source.
These two properties are kept to make the code easier to understand. Indeed, during the HFSQL Client/Server, SQL Server, Oracle or MySQL connection, ..Server is recommended because a server name must be specified.
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