Adding a new database, Add the sqlbase server to the sqlconsole display – Rockwell Automation Emonitor with a Gupta Multi-User Database User Manual

Page 38

Advertising
background image

I

NSTALLING

E

MONITOR

S

OFTWARE

WITH

A

G

UPTA

SQLB

ASE

M

ULTI

-U

SER

D

ATABASE

34

• •

Adding a new database

You may want to add another database to your system. You can use one Econfig database
for your configuration data and have multiple other databases for storing data similar to
the Entek database.

Add the SQLBase server to the SQLConsole display

You only have to follow this procedure once to add the server to the SQLConsole display.
If the server name appears in the SQLConsole display, you can skip these steps. The
default server name is SERVER1.

1. Start the Gupta SQLBase server if it is not running. Select Start > Programs > Gupta

> SQLBase 9.0.1 > SQLBase Database Engine.

2. Start the SQLConsole by selecting it from Start > Programs > Gupta > SQLBase

9.0.1 > SQLConsole DBA Utility.

3. The first time you run the SQLConsole, a message appears:

Select No to run in Enhanced mode.

4. Click Yes at the next dialog to create a local SQLConsole database.

5. Click Yes at the next dialog to use the default database name (SQLSCRVR), and leave

the password blank.

Before you add a new database, you must restart your computer at least once since you installed
Emonitor, in order to restart the Gupta SQLBase server.

Advertising