DAVIS FMS DriveRight Database Selection Guide (8186) - Manual (Page 7)

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. It should be noted that the MSDE database server is optimized for a maximum
of 5 simultaneous connections. Considering the fact that the DriveRight FMS
software may keep more than one connection alive, it is advisable to limit the
number of users to one at a time.
MySQL Installation
MySQL is a database server developed by a company named 'MySQL AB' as an
Open Source Project. It is considered fast, stable, and is easy to setup compared to
database servers like Oracle. Also, it is by far the least expensive multi-user
database server for use with the DriveRight FMS. For medium to large fleets, we
strongly recommend MySQL server, especially if you do not already have a
license for either Oracle or MS SQL server.
Server Installation
1. You must have a license for MySQL. (They can be purchased from MySQL
AB). MySQL Classic version is adequate for all DriveRight FMS applications.
2. Install MySQL Server. During installation of MySQL server, setting user
names and passwords is optional.
3. Make sure MySQL is running first. To do this go to Startup->Settings-
>Control Panel->Administrative Tools->Services. You will see a service name
titled MySQL. If it is not running, select it and right click to start it.
Client Installation
The client software, MySQL Connector/ODBC, must be installed on all computers
that will be running DriveRight FMS.
Note: MySQL Connector/ODBC 3.51.29 is required for running DriveRight FMS on a
Windows Vista, 7 or later operating system.Microsoft ODBC 3.51.29 for both 32-bit and
64-bit operating systems is available on the installation CD and will be copied onto your
computer with FMS. If you are using MySQL, you will need to install it.