Server (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage properties / HFSQL properties

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Server (Property)

In french: Serveur

Not 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, when you open a file that uses an open connection, that connection will be closed and reopened with the new parameters.

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:

a connection defined in the data model editor,
a connection defined with HConnect, HDescribeConnection or HOpenConnection.
a connection defined with a variable of type Connection.

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 is defined:
in the data model editor,
with the HDescribeConnection and HOpenConnection functions,
with the Connection type.

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 is defined:
in the data model editor,
with the HDescribeConnection and HOpenConnection functions,
with the Connection type.

<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.