RAD Studio (Common)
ContentsIndex
PreviousUpNext
Database Editor

Use this dialog box to set up the connection to a database.

Item 
Description 
Name  
Specifies the name of the database. This name refers to the database component from within the code of your application.  
Alias Name  
Specifies the BDE alias for the database. Choose a database aliases from the drop-down list. This list contains all aliases currently registered with the BDE. If you do not want to connect to a database that is registered as a BDE alias, you can set the Driver property instead. If you set the Alias property, the Driver property is cleared, as the driver type is implicit in the BDE alias.  
Driver Name  
Specifies the type of database represented by the database component. Choose a driver type such as STANDARD, ORACLE, SYBASE, or INTERBASE from the drop-down list. If the database server has an alias registered with the BDE, you can set the Alias instead. Setting the Driver automatically clears the Alias property, to avoid potential conflicts with the driver type implicit in the database alias.  
Parameter overrides  
Specifies the values of all login parameters when connecting to the database. The specific parameters depend on the type of database. To obtain a list of all parameters, as well as their default values, click the Defaults button. You can then modify the default values to the values you want to use.  
Defaults  
Sets the Parameter overrides to the default values for the driver type.  
Clear  
Removes all parameter overrides.  
Login Prompt  
Causes a login dialog to appear automatically when the user connects to the database. Uncheck the Login Prompt control to prevent the automatic login dialog. Most database servers (except for the file-based STANDARD types) require the user to supply a password when connecting to the database. For such servers, if the automatic login prompt is omitted, the application must supply the user name and password in some other manner. These can be supplied either by providing hard-coded parameter overrides, or by supplying an OnLogin event handler that sets the values for these parameters.  
Keep inactive connection  
Indicates that the application should remain connected to the database even if no datasets are currently open. For connections to remote database servers, or for applications that frequently open and close datasets, checking Keep inactive connection reduces network traffic, speeds up applications, and avoids logging in to the server each time the connection is reestablished. Uncheck Keep inactive connection to cause the database connection to be dropped when there are no open datasets. Dropping a connection releases system resources allocated to the connection, but if a dataset is later opened that uses the database, the connection must be reestablished and initialized.  
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!