To create the logical name for a database, select the Create option from the context-sensitive menu in the Databases tab in the Server configuration dialog box.
To modify the definition of a database's logical name, you must either:
- Select the Modify option from the context-sensitive menu in the Databases tab in the Server configuration dialog box.
The cursor must be positioned over the database name.
- Double-click the database name.
Data entry
Name
Logical name of the database. This is the name used to identify the database for the client.
This name is used in the "DB used" field in the Create/Modify a link dialog box of the client configuration.
Description
Remark associated with the database.
DBMS
List of the Database Management Systems handled by Visual/Web.
Possible settings:
- BTRIEVE
- DB2
- ODBC
- SQL Server
- Oracle
- JDBC
DB Name (or URL with JDBC)
Real name of the database in the specified DBMS.
Notes:
- With Btrieve DBMS's, the database name will be replaced by the path that leads to the directory in which the Btrieve files are located.
- With JDBC DBMS's, the database name is replaced by a URL of the type:
JDBC:DB2:BASE_NAME for DB2
and
JDBC:ORACLE:@BASE_NAME for Oracle.
JDBC driver
Java class implementing the JDBC driver supplied by the DBMS.
Field accessible for data input only if the JDBC DBMS is selected.
Profile
Database connection profile.
Specify a connection profile or select the value *SAME from the list. By selecting the value *SAME, you will be able to use the server connection profile to connect to the database.
The following operations are performed in the server:
- processing,
- database accesses.
The server is thus a client of a DBMS. As the DBMS client, it has to submit a profile in order to connect:
- if the profile is *SAME, the server will connect to the DBMS using the profile PAUL,
- if a specific profile is selected, the server will use this profile instead.
Password
Password for the profile.
This field will not be available if the *SAME profile is used.
Check boxes
Default DB
Checked |
The database specified in the "DB Name" field will be defined as the default database. This is the database that will be used if the value *DFT is left in the "DB used" field in the Create/Modify a link dialog box of the client configurator. |
Buttons
Create / Modify
This button validates the information entered and closes the dialog box.
In "creation" mode, the server will be created in the database.
Cancel
This button closes the dialog box without validating the information entered.