Before you begin, please take a moment to answer these questions:
- My network operating system is: __________________ I don’t know
- My network server (PC) is a Pentium _____MHz___ I don’t know
- My network server has this much RAM: ___ MB___ I don’t know
- My network server has this much unallocated RAM: ___ MB___ I don’t know
- My client workstations have mapped the network server as: ___ Drive Letter___ I don’t know
- My client workstations have this much RAM: ___ MB___ I don’t know
If you answered "I don’t know" to one or more of these questions, please do not attempt to install this software until you do know. You may wish to enlist the assistance of a network administrator.
The minimum recommended system configuration for client workstations is:
- Windows 95, Windows 98, Windows NT Workstation v4.x
- Pentium 133MHz
- 32MB RAM
This is a minimum recommended configuration. As with all Windows programs, SkillTrack's performance will improve if you add RAM and megahertz to the workstation.
To run the DEMO database, you can use a machine with no more power than that described for Client Workstations, above. For a production system, however we recommend:
- A Pentium 200MHz or faster machine with at least 128 MB of RAM
To provide best performance, the database server needs to allocate a memory cache of approximately 40% of the physical database size. For example, if your production database (SKT.db) is 100MB in size, you should allocate 40MB of your network server's total RAM to the SkillTrack database server cache. Use the SkillTrack Database Manager to configure the cache setting for your server. For the demo database, a cache of 4MB is more than adequate.
Note: If your server presently has 128MB of RAM, chances are you're already using most of it to run other services. Refer to your operating system documentation to determine how much RAM must be made available to the network server (assume at least 32MB) and how much is presently available before you allocate large chunks of it to the SkillTrack database server cache.
Supported Network Operating Systems:
Windows NT Server
Version 4, Service Pack 3 or Service Pack 5 (Service Pack 4 can be used, but it may be necessary to reinstall TCP/IP).
We have tested under Version 4.x.
Although a peer-to-peer Windows LAN can be used, we do not recommend this operating system for the network/database server. Windows NT and NetWare offer greater stability.
Installing and Setting up SkillTrack for Windows Demo
If you are installing the demo on a computer that is not a network server, follow the instructions for setting up on a Windows 95/98/NT Server. If your computer does not have a network card installed, look for the special instructions in a box similar to this one on the next page.
Insert the SkillTrack for Windows CD into your CD-ROM drive. The CD contains an autorun program which will present a set of installation options:
Windows 95/98/NT Server
Novell NetWare 4.x Server
Client for Windows Server
Client for NetWare Server
Choose the Server Installation option that is appropriate to your network operating system. If you are installing the demo on a client workstation, choose Windows 95/98/NT Server. The installation program will guide you through this process.
Running the demo on a Windows Server
If you are simply evaluating the demo on a Windows client workstation, a standalone PC, or your Windows network server, you may skip the remainder of this section and proceed to Starting the SkillTrack Database Server.
If you are installing the demo on a NetWare server, or if you wish to test the multi-user features of SkillTrack, you will need to run the appropriate Client Installation on one or more client workstations. Take the installation CD to each client workstation and run the Client Installation program for your network operating system.
Note: The program executable files are installed on the network server only! The client installations simply set up the ODBC, Borland Database Engine and Sybase SQL Anywhere files needed to let the client connect to the SkillTrack database. Refer to the README.txt file in the directory where you install the SkillTrack server files (the default for Windows is C:\SKT; the default for NetWare is F:\SKT). README.txt lists all the files we add to your computers and the changes we make to your Windows registry on each client.
Please create desktop icons for the clients, pointing to SKT.exe on the server. The easiest way to do this is to use Windows Explorer: Create a shortcut to SKT.exe and drag it onto the client’s desktop.
If you prefer to have an entry on the Windows Start | Programs menu, right-mouse-click on the Start button and select Open from the pop-up menu. Open the folder labeled Programs. Within the Programs group, use the File menu option New -> Shortcut. A wizard will guide you through the process of locating the file you want to point to:
[Your Mapped Network Drive]:\SKT\SKT.exe
Press the Next button, and fill in the name you want to see on the menu (SkillTrack for Windows). Press the Finish button to complete the process.
Starting the SkillTrack Database Server
Working at the PC where you ran the Windows Server installation, use Windows Explorer to navigate to the folder where the program files were installed. If you accepted the defaults during installation, this will be C:\SKT. In this folder you will find an application file called SKTMGR.exe. This is the SkillTrack Database Manager. Run this program.
When SKTMGR first comes up, it opens a Help file. You don’t have to read this now, but you will definitely want to have your network administrator read it so that (s)he can configure SkillTrack to make backups of the database.
Configuring SKTMGR to run the SkillTrack Demo Database (Windows servers only)
SKTMGR has five pages. For now, we are interested in just these three:
If you are running SKTMGR on the PC where you installed the SkillTrack program files and database (and you should be), place a checkmark in the control labeled This computer is the SkillTrack network database server.
Next, choose one of the first two options in the group labeled Server startup. If you choose Automatic, the database server will be started every time the computer is turned on. If you choose Manual, the server must be started manually using the Start/Stop Server button on the Control Panel page.
The Database engine control should be pointing to the SQL Anywhere database server program: C:\Program Files\Common Files\SQLAny50\Win32\DBSRV50.exe. If it is not, press the icon depicting the open folder and navigate to the directory where this file is located.
If your computer does not have a network card, you should select DBENG50.exe instead of DBSRV50.exe. DBENG50.exe runs the SQL Anywhere database engine in a standalone environment, whereas DBSRV50.exe runs the engine as a multi-user server, and requires the computer to have a network card installed.
If you are using DBENG50.exe, you need to press the Advanced Options… button to remove checkmarks from all items and leave the Server options and Database options fields blank. The only fields that should have values in the Advanced Options dialog are Server name and Database name, and both of those should say SkillTrack.
The Database file control should be pointing to the directory where the SkillTrack demo database was installed. If you accepted the default settings during installation, this will be C:\SKT\Database\SKT.db.
Set the Cache size to a level that works within your computer’s RAM configuration. Refer to the F1 Help for more information about determining an appropriate cache size. If you are simply trying to run the demo database, you can set the cache size to 4MB.
The control labeled Database file should already display the path to the location where you installed the SkillTrack database. If you accepted the defaults during installation, this would be C:\SKT\Database\SKT.db for Windows, and F:\SKT\Database\SKT.db for NetWare.
You must indicate a Backup directory. The obvious place to store your backups is directly below the \SKT\Database directory: C:\SKT\Database\Backup for Windows, or F:\SKT\Database\Backup for NetWare. If your network administrator would prefer to store the backups somewhere else, he can change this setting at a later time.
Press the Apply button to save your settings on the Database Server and Backup Configuration pages.
Choose the Start/Stop Server button. Select Run server and press the OK button.
Novell NetWare Server
Starting the SkillTrack database server on NetWare must be done manually. You will use the SKTMGR program for scheduling and running backups of the database, but not for starting and stopping the server.
The following discussion assumes you accepted the default location for installing on the NetWare server. Change the path to SKT.DB if you did not accept the default location during installation.
At the NetWare server console type (this is case sensitive):
LOAD SYS:\SKT\SQLANY50\DBSRV50.NLM –ti 0 –c 4M –x ipx SYS:\SKT\DATABASE\SKT.DB –n SkillTrack
Note that the switch –ti 0 is using zero, not the letter ‘oh’. The switch –c 4M represents the size of the database server cache. Refer to the discussion on page 1 of this document concerning the recommended size for the database server cache.
If you want the SkillTrack database server to load every time you restart your network server, add the LOAD statement to your AUTOEXEC.NCF file.
Running SkillTrack for the first time
Using your desktop icon or Start menu option, start SkillTrack for Windows. The first time SkillTrack runs on your server, an initialization wizard will prompt you to enter a password for the SkillTrack super user, $$$. Just follow the instructions on each page of the wizard.
And when the wizard is done… press F1.
Please read this…
Read the Getting Started chapter in the SkillTrack online Help. It contains information you need to know. Our testers tell us that the help files for SkillTrack are among the best they’ve seen; you can learn how to use SkillTrack by pressing F1 from anywhere in the program. So please, we beg you… read the help files!
If you won’t read anything else in the help files, at least read the first topic in the Getting Started chapter, entitled Things You Absolutely Must Know About SkillTrack.
Please read the SkillTrack Software License Agreement. It is installed on the server in the same directory where SKT.exe is installed. It is also installed on every client in C:\Program Files\SkillTrack. You agreed to its terms when you installed the software, so you really should know what it says.