Rockwell Automation Emonitor with a Gupta Multi-User Database - Manual (Page 4)

I NSTALLING E MONITOR S OFTWARE WITH A G UPTA SQLB ASE M ULTI -U SER D ATABASE
iv
• •
•
•
•
4 • Upgrading from a previous version 21
Updating the SQLBase software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Running the Emonitor upgrade program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Installing the EDS files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Restructuring the database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
5 • Database maintenance 29
Using SQLTalk Interactive . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Checking the integrity of your database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
Speeding up database access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
Running the Gupta SQLBase Server as a program . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
Backing up your data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
How often should I back up my data? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
What files and directories do I need to back up? . . . . . . . . . . . . . . . . . . . . . . . . . 32
What is the correct backup procedure for SQLBase databases? . . . . . . . . . . . . . 32
Using the correct storage media for your data . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Adding a new database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Add the SQLBase server to the SQLConsole display . . . . . . . . . . . . . . . . . . . . . 34
Add the new database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
6 • Troubleshooting 39
Troubleshooting database connections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
What version ODBC driver should I use? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
What is this error message about a DLL conflict when I start the program? . . . 39
Why am I getting a configuration file error? . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Why can’t I connect to the database? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
Why can’t it find the ERROR.SQL file? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
My other SQLBase programs cannot find the SQL.INI file. . . . . . . . . . . . . . . . . 40
Do I add DBNTSRV to the Windows Firewall exceptions? . . . . . . . . . . . . . . . . 40
Troubleshooting during the installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
Do I have to install certain online components to certain computers?. . . . . . . . . 41
Why can’t I run the Emonitor installation program on Windows 2000 or XP?. . 41
What happens if the computer gets turned off in the middle of an installation? . 41
Troubleshooting FactoryTalk Activation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
Index 43