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

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.5 of the SQL Server driver is installed (unlikely), then you will
need to edit it to look like {SQL Server}.
2. Once the information is entered, click Connect to Database. DriveRight FMS
software launches and connects to the database.
Oracle Installation
Since Oracle server installation and administration are complicated, you will
require an Oracle database administrator to use Oracle with DriveRight FMS.
Server Installation
1. If you don’t already have a license for Oracle server, buy one from Oracle.
2. The DriveRight FMS software has been tested with the Oracle9i server and
with Oracle9i client. Since the DriveRight FMS software executes only the
standard SQL statements, the software should work with previous or later
versions of Oracle server and client.
3. Create the database DRight with SID, using the Database Configuration
Assistant.
4. Create a Net Service Name called DRight, with the SID created in Step 3.
5. Create a user name and password for FMS users to connect to Oracle server.