Owner manual

ManualsBrandsDAVIS ManualsCarFMS DriveRight Database Selection Guide (8186)

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.

Summary of content (20 pages)

PAGE 1
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.
PAGE 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. Beginning in version 3.9.2, DriveRight FMS will automatically compact the Access database when the user exits. Be aware that it is a good practice to close FMS regularly to allow the Access database to be compacted and repaired. MSDE Considerations MSDE stands for Microsoft Desktop/Data Engine, which is a scaled down version of the SQL Server.
PAGE 3
Active Database Size Recommendations The recommendations displayed in the table below are based on tests and calculations made with these assumptions: • 10 trips per day per vehicle. • Trip duration is 1 hour (10 hours driving time per day per vehicle). • GPS data logged every 10 seconds. Number of Vehicles Active Data stored in Database Remarks and Recommendations 25 Up to 1 year Backup data once a month for application performance.
PAGE 4
Selection Considerations: Multi-User Davis recommends using either MySQL, MS SQL Server, or Oracle if more than one user will be accessing the data at a time, if the fleet has more than five vehicles, or if you are logging GPS data for more than one vehicle. MySQL, MS SQL Server & Oracle Considerations MySQL, Oracle and MS SQL Server database servers are very powerful databases, which can support large amounts of data and multiple simultaneous connections with good performance.
PAGE 5
Database Configuration Not applicable. The database is automatically configured if it is selected during DriveRight FMS initial configuration. Database Connection Please refer to the “DriveRight Fleet Management Software Getting Started Guide” for DriveRight FMS installation and configuration instructions: 1. When you run DriveRight FMS, the Select Database Type dialog box displays. Select MS Access and click OK. A dialog box is displayed with the path in which the database will be created.
PAGE 6
MSDE Installation The Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) is another database option. If using the MSDE Server, MSDE 2000 is required for FMS 3.7. Server Installation 1. Please refer to Microsoft MSDE installation documentation for instructions on installing and configuring your MSDE database. 2. Make sure the MSDE Server is running. To do this go to: Start>All Programs->Startup->MSDE->Service Manager. Press Start/Continue, the green arrow icon to start MSDE.
PAGE 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 will need to edit it to look like {SQL Server}. 3. If the database is empty when you connect, you are prompted to enter the location name and address to be associated with all the data at your location. 4. After entering the location name and address, click OK and the DriveRight software will start. 5.
PAGE 8
Database Configuration 1. With MySQL running, install and run the DriveRight FMS on the same machine as the database server. This is only required for database configuration. After the database is configured, remove DriveRight FMS from the server. When the database configuration is complete, you will be able to connect to the MySQL server from any PC on the local area network.
PAGE 9
Database Connection on User’s Computer 1. When you run DriveRight FMS for the first time, the Database Type Selection dialog box displays. Select MySQL and click OK. 2. The Database Connection dialog box displays. Enter the machine name of MySQL Server in the Machine Name text box. Contact your system administrator for the MySQL machine name. MySQL ODBC 3.51 Driver 3. Click Connect to Database to finish the database connection.
PAGE 10
Database Configuration The MS SQL server can be configured two ways, on the server itself or from a user’s computer. Note: The server can also be configured without installing DriveRight FMS on the server, by running the DBConfig_DriveRight_MSSQL.bat file. See “Appendix A: Configuring MS SQL Server Database Manually” on page 17. To Configure the Database on the Server: 1. With MS SQL Server running, install and run DriveRight FMS on the same machine as the database server.
PAGE 11
The Database Connection dialog box displays the following fields: • Server Name — Defaults to the local machine name. You may need to change this if you do not use the local machine name. • Database Name — Defaults to DriveRight_MSSQL but can be changed to any other database running on the server. • 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 will need to edit it to look like {SQL Server}. 4.
PAGE 12
The Database Connection dialog box displays: The Database Connection dialog box displays the following fields: • Server Name — Defaults to the local machine name. You may need to change this if you do not use the local machine name. • Database Name — Defaults to DriveRight_MSSQL but can be changed to any other database running on the server. • ODBC Driver — This will not need to be changed in most installations. If version 2.
PAGE 13
Client Installation The Oracle client must be installed on all computers running DriveRight FMS. Please check with your Oracle database administrator for client licensing. Note: If you are running DriveRight FMS on a Windows Vista or 7 operating system, please contact your database administrator or Oracle for Oracle Client with Windows Vista or 7 support. The following steps are for installing Oracle Client 9i. If you install a different version of Oracle Client, some steps may vary.
PAGE 14
15. 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 installation is finished. See “Creating and Configuring Oracle DSN” on page 15 for the next steps in the process. Creating Listener and Net Service Name Manually If you are in this section, you had problems creating a service name while creating Oracle Client. If everything worked fine in the previous section move on to the next section. 1.
PAGE 15
Creating and Configuring Oracle DSN 1. 2. 3. 4. Go to Start->Settings->Control Panel. Double click Administrative Tools, and select Data Sources. In the Data Sources dialog box, select the System DSN tab. Click Add, and in the list of drivers select Oracle in OraHome90 (located almost at the bottom of the list) and click Finish. 5. In Data Source Name, enter DriveRightOracle. In TNS Service Name, select DRIGHT. Enter the user name and password provided by your database administer and click OK.
PAGE 16
4. 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 exit. 6. If the database is empty when you connect, you are prompted to enter the location name and address to be associated with all the data at your location. After entering the location name and address, click OK and DriveRight FMS starts. Database Connection on the User’s Computer 1.
PAGE 17
Appendix A: Configuring MS SQL Server Database Manually If a direct configuration of the database files on the MS SQL server can not be permitted, the database can be configured manually by using the following instructions. The OSQL command utility should be installed to run the script. 1. Go to Start->Run. 2. Type cmd and click OK. The DOS command window displays. 3. Change the directory by entering the following in the command line: cd C:\Program Files\DriveRight 4.
PAGE 18
Appendix B: Configuring Oracle Database Manually If a direct configuration of the database files on the Oracle server can not be permitted, the database can be configured manually by using the following instructions. The SQLPlus command utility should be installed to run the script. 1. Go to Start->Run. 2. Type cmd and click OK. The DOS command window displays. 3. Change the directory by entering the following in the command line: cd C:\Program Files\DriveRight 4.
PAGE 19
Contacting Davis Technical Support If you have questions about DriveRight FMS, or encounter problems installing or using the software, please contact Davis Technical Support. Most questions can be answered while you're on the phone. Sorry, we are unable to accept collect calls. (510) 732-7814 – Monday through Friday, 7:00 a.m. to 5:30 p.m. Pacific Time. (510) 670-0589 – Fax to Technical Support. support@davisnet.com – E-mail to Technical Support. info@davisnet.com – E-mail to Davis Instruments. www.
PAGE 20
Product Number: 8186 DriveRight® Fleet Management Software Database Selection Guide Copyright © 2012 Davis Instruments Corp. All rights reserved. Part Number: 7395.195 Rev. K Manual (10/18/12) This product complies with the essential protection requirements of the EC EMC Directive 2004/108/EC. DriveRight and CarChip are registered trademarks of Davis Instruments Corp.