The
User property is used to manage the user of a connection (HFSQL Client/Server, OLE DB, etc.). You can:
- Identify the user of a connection (HFSQL Client/Server, OLE DB, etc.).
- Define the user of a 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.
Remark: The connection can correspond to:
MyConnection is Connection
// Describe the connection
MyConnection.User = "FP"
MyConnection.Password = "Test"
MyConnection.Server = "MYSERVER"
MyConnection.Database = "Database"
MyConnection.Provider = hAccessHFClientServer
MyConnection.Access = hOReadWrite
MyConnection.ExtendedInfo = "Extended information"
MyConnection.CursorOptions = hClientCursor
HOpenConnection(MyConnection)
Syntax
Identifying the user of a connection Hide the details
<User name> = <Connection used>.User
<User name>: Character string
Name of the user of the connection.
<Connection used>: Connection name
Name of the connection used. This name was defined:
Defining the user of a connection Hide the details
<Connection used>.User = <New username>
<Connection used>: Connection name
Name of the connection used. This name was defined:
<New username>: Character string
Name of the user of the connection.
Remarks
CtUserName is used to define the user of a connection. This property is kept for backward compatibility. It is recommended to use the
User property.