Pre-requisites

1. MySQL Server 5.0
2. GUI Tools for MySQL
3. ODBC Driver for MySQL

1. Install MySQL Server 5.0 from CD (9.07.01\MySQL\mysql-essential-5.0.xx-win32.msi)
1. Choose Setup type as typical.
2. When asked to sign up with MySQL, skip the registration.
3. When wizard completes installation, keep 'Configure the MySQL Server check box as it is (i.e. checked)
4. Click on finish
2. This opens up a MySQL Server Instance Configuration Wizard 1.0.8
1. Click next
2. Select standard configuration type and click next
3. Keep default settings i.e.
1. Install as Windows Service: Yes
2. Service Name: MySQL
3. Lanuch the MySQL Server automatically: Yes
4. Include Bin Directory in Windows Path: Yes
5. Click next
4. Check on Modify Security Settings
1. Set new root password as snehapadma
2. Enable root access from remote machine
3. Do not create a anonymous account
4. Click next
5. Click on Execute
1. If some error appears, click on retry.
6. Click finish.

Other Pre-requisites

Creating Database

Creating DSN for Time Office and CentralStation

1. Click on Start -> Run
1. For 32 bit OS version of Windows XP and Windows 7: type in ODBCAD32 and click OK
2. For 64 bit OS version of Windows 7: type in C:\WINDOWS\SysWOW64\odbcad32.exe and click OK
2. Click on tab System DSN
3. Click on Add to create DSN for Time Office
4. Select MySQL ODBC driver as installed in your system and click Finish
5. Put in values as follows
1. Data Source Name: dsnsptodb
2. Server: ipaddress of the server (normally localhost)
3. User: sptodbu
4. Password: sptodbpp
5. Database: sptodb
6. Click on Test to ensure that your settings are successful.
7. Click on OK.
8. Click on Add to create DSN for CentralStation
9. Select MySQL ODBC driver as installed in your system and click Finish
10. Put in values as follows
1. Data Source Name: dsnspcsdb
2. Server: ipaddress of the server (normally localhost)
3. User: spcsdbu
4. Password: spcsdbpp
5. Database: spcsdb
11. Click on Test to ensure that your settings are successful.
12. Click on OK, OK.

Installing Snehapadma CentralStation

1. Run setup.exe from the CD folder (9.07.01)

Visual Basic Runtime