![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio XE8 (C++ Win32) » Using DBISAM » Server Administration |
Method | Description |
GetServerConfig | This method retrieves the global database server settings for maximum allowed connections, connection timeouts, dead session settings, the temporary files directory, and authorized and blocked IP addresses. |
ModifyServerConfig | This method modifies the global database server settings. |
GetServerLogCount | This method retrieves the total number of log records present in the current log file. Calling this method triggers the TDBISAMEngine OnServerLogCount event. If an event handler is defined for this event, then it is called to retrieve the count from whatever storage medium is being used for the log file. |
GetServerLogRecord | This method retrieves the Nth log record from the current log file. Calling this method triggers the TDBISAMEngine OnServerLogRecord event. If an event handler is defined for this event, then it is called to retrieve the specified log record from whatever storage medium is being used for the log file. |
StartAdminServer | This method causes the database server to begin listening for administrative connections on the IP address and port specified by the TDBISAMEngine ServerAdminAddress and ServerAdminPort properties. |
StopAdminServer | This method causes the database server to stop listening for administrative connections. |
StartMainServer | This method causes the database server to begin listening for regular data connections on the IP address and port specified by the TDBISAMEngine ServerMainAddress and ServerMainPort properties. Calling this method triggers the TDBISAMEngine OnServerStart event. |
StopMainServer | This method causes the database server to stop listening for regular data connections. Calling this method triggers the TDBISAMEngine OnServerStop event. |
GetServerUTCDateTime | This method retrieves the current date and time from the server in UTC (Coordinated Universal Time). |
GetServerUpTime | This method retrieves the total up time of the database server in seconds. |
GetServerMemoryUsage | This method has been deprecated and always returns 0 as of version 4.17 of DBISAM and the introduction of the new memory manager used in the DBISAM database server. Please see the Replacement Memory Manager topic for more information. |
GetServerSessionCount | This method retrieves the total number of sessions present on the database server at the time of the method call.![]() |
GetServerConnectedSessionCount | This method retrieves the total number of sessions on the database server that are currently connected at the time of the method call.![]() |
GetServerSessionInfo | This method retrieves information about the specified session such as its unique session ID, when it was created, when it was last connected, the user name, the IP address of the user, and whether the connection is encrypted.![]() |
DisconnectServerSession | This method disconnects the specified session, but does not remove the session from the database server. Once the session is disconnected it is considered to be a dead session.![]() |
RemoveServerSession | This method removes the specified session completely from the database server.![]() |
GetServerUserNames | This method will retrieve a list of user names that are currently defined on the database server. |
GetServerUser | This method will retrieve information about a specific user, including the user's password, a description of the user, and whether the user is an administrator for this server. |
AddServerUser | This method will add a new user. |
ModifyServerUser | This method will modify a user's information. |
ModifyServerUserPassword | This method will modify only a user's password. |
DeleteServerUser | This method will delete a user. |
GetServerDatabaseNames | This method will retrieve a list of database names that are currently defined on the database server. |
GetServerDatabase | This method will retrieve information about a specific database, including the database's description and the actual physical path to the database tables.![]() |
AddServerDatabase | This method will add a new database. |
ModifyServerDatabase | This method will modify a database's information. |
DeleteServerDatabase | This method will delete a database. |
GetServerDatabaseUserNames | This method will retrieve a list of users that are assigned rights to a specific database. |
GetServerDatabaseUser | This method will retrieve the user rights of a user for a specific database. |
AddServerDatabaseUser | This method will add user rights for a specific user to a specific database. |
ModifyServerDatabaseUser | This method will modify the user rights of a user for a specific database. |
DeleteServerDatabaseUser | This method will delete the user rights of a user for a specific database. |
GetServerProcedureNames | This method will retrieve a list of server-side procedure names that are currently defined on the database server. |
GetServerProcedure | This method will retrieve information about a specific server-side procedure, specifically the server-side procedure's description. |
AddServerProcedure | This method will add a new server-side procedure. |
ModifyServerProcedure | This method will modify a server-side procedure's information. |
DeleteServerProcedure | This method will delete a server-side procedure. |
GetServerProcedureUserNames | This method will retrieve a list of users that are assigned rights to a specific server-side procedure. |
GetServerProcedureUser | This method will retrieve the user rights of a user for a specific server-side procedure. |
AddServerProcedureUser | This method will add user rights for a specific user to a specific server-side procedure. |
ModifyServerProcedureUser | This method will modify the user rights of a user for a specific server-side procedure. |
DeleteServerProcedureUser | This method will delete the user rights of a user for a specific server-side procedure. |
GetServerEventNames | This method will retrieve a list of scheduled event names that are currently defined on the database server. |
GetServerEvent | This method will retrieve information about a specific scheduled event, specifically the scheduled event's description and scheduling parameters. |
AddServerEvent | This method will add a new scheduled event. |
ModifyServerEvent | This method will modify a scheduled event's information. |
DeleteServerEvent | This method will delete a scheduled event. |
Property | Setting |
SessionType | This property must be set to stRemote. |
RemoteEncryption | This property must be set to True. |
RemoteEncryptionPassword | This property must be set to the same password as the ServerEncryptionPassword property of the TDBISAMEngine component that the session is connecting to. |
RemoteAddress | This property must be set to the IP address of the database server as it appears to remote machines. You may optionally use the RemoteHost property if there is DNS information available for the database server that you are connecting to. |
RemotePort | This property must be set to the administrative port as it appears to remote machines. You may optionally use the RemoteService property if there is service information available for the database server administrative port that you are connecting to.![]() |
RemoteUser | This property must be set to the name of a valid administrator user for the database server that you are connecting to. |
RemotePassword | This property must be set to the proper password for the user name specified by the RemoteUser property. |
{ MyDBISAMSession->SessionType=stRemote; MyDBISAMSession->RemoteEncryption=true; // Assume the default encryption password in use MyDBISAMSession->RemoteAddress="192.168.0.1"; MyDBISAMSession->RemotePort=12006; MyDBISAMSession->RemoteUser="Admin"; MyDBISAMSession->RemotePassword="DBAdmin"; MyDBISAMSession->Open(); try { MyDBISAMSession->AddRemoteUser("Test","Test123456", "Test User",false); MyDBISAMSession->AddRemoteDatabaseUser("AccountingDB","Test", TDatabaseRights()<<drRead<<drInsert<<drUpdate<<drDelete); } __finally { MyDBISAMSession->Close(); } }
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |