Davis FMS DriveRight Database Selection Guide (8186) Manual de usuario descargar pdf

Davis Instruments, 3465 Diablo Avenue, Hayward, CA 94545-2778 U.S.A. • 510-732-9229 • www.davisnet.com

DriveRight

Fleet Management Software

Database Selection Guide

Use this guide to help you select the right database to use with your DriveRight

Fleet Management Software (FMS), and to help you perform any required

database installation procedures before you run DriveRight FMS for the first time.

DriveRight FMS supports the following databases:

• Single-User Databases:

• MS Access (Microsoft Access) (all required software included)

• MSDE 2000 (Microsoft Desktop/Data Engine not supported in the

Windows Vista or later operating system)

• Multi-User Databases:

• MySQL

• MS SQL Server (Microsoft SQL Server)

• Oracle

When you first run DriveRight FMS, you will be required to select a database to

use with the software. Each of the supported databases for DriveRight FMS have

their advantages and disadvantages. First, we’ll look at the selection

considerations for each of the supported database types. Later in this document we

present the installation procedure for each of the databases.

Selection Considerations: Single-User

Review the following considerations for each database and then select the best

database for your situation.

MS Access Considerations

Of the supported databases, MS Access is the easiest to install and use.

• There is no additional software to buy if you use MS Access. DriveRight FMS

automatically installs all the necessary components when you first run the

program.

• MS Access does have limitations to the number of users connected

simultaneously to the database, the size of the database, and reliability of the

database.

• MS Access is only recommended for installations that have one user.

• Maximum database size for MS Access is 2 gigabytes.

• MS Access is only recommended for small fleets of five vehicles or less. Be

aware that if you are logging GPS and vehicle speed data or other CarChip

parameter data, the database size increases very rapidly since GPS and vehicle

speed data is logged much more frequently than data from the DriveRight

console. In such cases, if you decide to go with MS Access database, it is

advised to backup your data at least once a month.

1 2 3 4 5 6 ... 19 20

Indice de contenidos

Pagina 1 - Database Selection Guide

Davis Instruments, 3465 Diablo Avenue, Hayward, CA 94545-2778 U.S.A. • 510-732-9229 • www.davisnet.com® 1DriveRight® Fleet Management SoftwareDataba

Pagina 2 - MSDE Considerations

10Database ConfigurationThe MS SQL server can be configured two ways, on the server itself or from a user’s computer.Note: The server can also be conf

Pagina 3

11The Database Connection dialog box displays the following fields:• Server Name — Defaults to the local machine name. You may need to change this if

Pagina 4 - MS Access Installation

12The Database Connection dialog box displays:The Database Connection dialog box displays the following fields:• Server Name — Defaults to the local m

Pagina 5 - Database Connection

13Client InstallationThe Oracle client must be installed on all computers running DriveRight FMS. Please check with your Oracle database administrator

Pagina 6 - MSDE Installation

1415. When you are prompted to configure another Net Service Name, select No and click Next. Then click Finish.16. Click Exit. The Oracle 9i client in

Pagina 7 - MySQL Installation

15Creating and Configuring Oracle DSN 1. Go to Start->Settings->Control Panel.2. Double click Administrative Tools, and select Data Sources.3. I

Pagina 8

164. Enter the user name and password created in step 4 of the Server Installation procedure.5. Click Connect to Database to finish or click Cancel to

Pagina 9 - MS SQL Server Installation

17Appendix A: Configuring MS SQL Server Database ManuallyIf a direct configuration of the database files on the MS SQL server can not be permitted, th

Pagina 10 - Database Configuration

18Appendix B: Configuring Oracle Database ManuallyIf a direct configuration of the database files on the Oracle server can not be permitted, the datab

Pagina 11

19Contacting Davis Technical SupportIf you have questions about DriveRight FMS, or encounter problems installing or using the software, please contact

Pagina 12 - Oracle Installation

2• An MS Access database needs to be compacted on a regular basis to maintain proper performance and prevent the database from becoming too big. Begin

Pagina 13 - Client Installation

Pagina 14

3Active Database Size RecommendationsThe recommendations displayed in the table below are based on tests and calculations made with these assumptions:

Pagina 15

4Selection Considerations: Multi-UserDavis recommends using either MySQL, MS SQL Server, or Oracle if more than one user will be accessing the data at

Pagina 16

5Database ConfigurationNot applicable. The database is automatically configured if it is selected during DriveRight FMS initial configuration.Database

Pagina 17 - Manually

6MSDE InstallationThe Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) is another database option. If using the MSDE Server, MSDE 20

Pagina 18 - YourServiceName

7• ODBC Driver — This will not need to be changed in most installations. If version 2.5 of the SQL Server driver is installed (unlikely), then you wil

Pagina 19

8Database Configuration1. With MySQL running, install and run the DriveRight FMS on the same machine as the database server. This is only required for

Pagina 20

9Database Connection on User’s Computer1. When you run DriveRight FMS for the first time, the Database Type Selection dialog box displays. Select MySQ