(Contents)(Previous)(Next)

Connecting to the Database

After starting, you must connect to your ADABAS server. This can be done in the following ways:

1) Connect by Using the Database/Connect Menu

Connecting is done via the connect window. If the connect was successful, it is saved in the Database menu to be used for a direct connect.

2) Connect Directly by Using the Database Menu

If entries for a direct connect are available in the Database menu, you can connect to the database by selecting the desired entry.

3) Connect Automatically by Using the ~ Toolbar Button

If entries for direct connects were made to the Database menu, the ~ toolbar button can be used to repeat the last connect.

To close a current database connection, select the Database/Disconnect menu item. A disconnect can be required in the following case: you are only allowed to have one connection to the database and you want to connect to the database from another ADABAS component without leaving QueryPlus. No disconnect is needed for a reconnect. The Database/Disconnect menu appears after a connect.

In the following, these three ways will be explained in greater detail.

1) Connect by Using the Database/Connect Menu

To connect to the database, select the Database/Connect menu. First select a data source. You can create the data source by using the ODBC Administrator.

The QueryPlus connect window then appears into which the required values are to be entered.

The username and password are automatically displayed in uppercase characters. If case-sensitivity is desired, the username and password must be enclosed in double quotation marks. The double quotation marks are also needed when the name contains special characters. If a double quotation mark occurs in the name, it must be specified twice.

For "serverdb", the name of the database (SERVERDB) must be specified.

For "servernode:", the network node name of the database server must be specified.

If a connect is successful, it is entered in the Database menu to enable the user to connect directly to another QueryPlus session. The specifications for User, Serverdb, and Servernode are saved. According to the selected option (see Section Save Password for a Direct Connect), the password is also saved or not. If it is saved, it is used with the entry associated with it for a direct connect. If it is not saved, the connect window is displayed with the connect data, except for the password which must still be entered.

Up to ten entries for a direct connect can be made to the Database menu. If there are already ten entries and another connect is to be added, the connect used least is deleted. Entries for a direct connect are ordered according to the frequency of use. The last connect is in first place.

If you want to remove some entries for a direct connect from the Database menu or if you want to change the order of the entries, you can do so when entering the options for a connect (see Section Save Password for a Direct Connect).

2) Connect Directly by Using the Database Menu

The entries for a direct connect made to the Database menu indicate which user connected to which Serverdb on which Servernode. By selecting the corresponding entry, the desired user is connected to the desired database. The option set (see Section Save Password for a Direct Connect) determines whether the password is requested for the direct connect or not.

3) Connect Automatically by Using the ~ Toolbar Button

If the Database menu contains entries for direct connects, QueryPlus displays in the status line the last entry from the Database menu used for a connect. If a new connect is to be performed with that entry, it is sufficient to select the ~ toolbar button.


(Contents)(Previous)(Next)