Adding a new database, Add the sqlbase server to the sqlconsole display – Rockwell Automation Emonitor with a Gupta Single-User Database User Manual
Page 38
I
NSTALLING
E
MONITOR
S
OFTWARE
WITH
A
G
UPTA
SQLB
ASE
S
INGLE
-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.