Database maintenance, Using sqltalk interactive – Rockwell Automation Emonitor with a Gupta Single-User Database User Manual

Page 33

Advertising
background image

29

4

Database maintenance

This chapter describes specific procedures for maintaining your database. These steps will
help your database speed and efficiency. Note that the procedures in this document apply
to Emonitor installations using the single-user or network (multi-user) versions of the
Gupta SQLBase database software.

Using SQLTalk Interactive

SQLTalk is the Gupta SQLBase program that allows you to communicate directly with
your database. Some of the procedures in this document require that you use SQLTalk.

1. Make sure that all users are logged out of Emonitor, and that no one is accessing the

database with SQLTalk or another utility.

2. From the Start menu, click Programs > Gupta > SQLBase 9.0.1 > SQLTalk

Interactive SQL.

3. From the Session menu, click Connect, or press F2. The Connect dialog appears.

4. Enter the database name, username, and password for your database. For the Entek

database, the default user name is

entek

, and the default password is

euser

. For the

EConfig database, the default username is also

entek

, and the default password is

also

euser

. The name and password are not case-sensitive. Passwords are encrypted.

5. Click Connect to connect to the database. Your database name should appear in the

Current Connections box.

6. Select the database in the Current Connections box and click Use, and then click

Close.

Advertising