0 installation, 1 system requirements, 0 database interface – Rice Lake MSI-8000 RF Remote Display - ScaleCore 2 Database Program (Sc2Db) User Manual

Page 6: 1 jdbc driver installation, 2 jdbc driver configuration, Installation, Database interface

Advertising
background image

2 ScaleCore 2 Database Operator’s Manual

2.0

Installation

The Sc2Db is distributed in the default configuration for Microsoft Windows

®

operating system.

When using a single compressed (.zip) file distribution, unzip the program to a location on the local computer and
run the application. The location of the executable is referenced as the

installation folder

throughout this operator’s

manual. There is no further installation required for the application.

2.1 System Requirements

Following are the typical system requirements to run the Sc2Db application. Specifications are subject to change
without notice.

Typical

Windows XP/Vista/7

®

Operating System

Windows

®

Embedded

Disk Usage: <200MB

Display: 800x600 or greater

Other Operating Systems:

Additional operating systems may be supported with the restriction of requiring TCP/IP device communications
exclusively (no RS-232 serial communications are supported). Please contact MSI for details.

3.0

Database Interface

The Sc2Db application uses Java JDBC technology to connect to a database. The application comes with support for

MySQL

and Microsoft SQL. Any JDBC driver can be loaded and configured. The following procedure describes

this process.

3.1 JDBC Driver Installation

Under the

installation folder

, is a folder called lib. Place the JDBC driver JAR (Java Archive) file in this folder.

3.2 JDBC Driver Configuration

Under the

installation folder

, is a file called db.properties, Open this with a text editor and complete the JDBC

configuration by setting the user name, password, driver class, and connection URL. For complete details refer to the
JDBC driver documentation.

Advertising