IBDatabase Editor dialog box

From RAD Studio
Jump to: navigation, search

Go Up to Database Dialog Boxes

The Database Editor dialog box sets up the properties of a database that specify the connection that should be made to a database. This dialog box allows you to specify the type of database, the connection parameters, the user name, SQL role, and password, and whether or not a login prompt is required.

These properties of the database component, as well as others, can also be specified using the Object Inspector.

To display the Database Editor dialog box, double click on an IBDatabase component.

Dialog box options

Connection

Option

Meaning

Local

Indicates that the database is on the local server. Enables the Browse button, allowing you to search for the database with a Open File dialog.

Remote

Indicates that the database is on a remote server. Activates the Protocol and Server fields

Protocol

Sets the protocol for attaching to the remote server. The protocol can be TCP/IP, Named Pipe, or SPX.

Server

The name of the remote server.

Database

The name of the database.



Database Parameters

Option

Meaning

User Name

The name of the database user.

Password

The password for the database user.

SQLRole

The SQLRole name used to connect to the database.

Character Set

The character set used to connect to the database.

Login Prompt

Indicates whether a login prompt is required to access the database.

Settings

Displays the current parameters and allows you to add other parameters.For example:user_name=sysdbapassword=masterkeysql_role_name=financelc_ctype=WIN1252For more information on database parameters, see the InterBase API Guide.