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

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.