Software Installation


Please note that the instructions in italics are only for the server machine and are not needed for the client machine.

Database

Snehapadma CentralStation requires MySQL Server 5.0. The application communicates to server using ODBC. You might also want to install GUI tools for MySQL. Following are the links for these.
Some of the above components can also be installed from the Snehapadma CentralStaion CD.

To install MySQl server, please note the following direction carefully:
  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

  1. Run MySQL GUI Tools Installation (MySQL Administrator and Query Browser) from CD (9.07.01\MySQL\mysql-gui-tools-5.0-r11a-win32.msi)
  2. Run MySQL ODBC Drivers Installation 
    1. For Windows XP 32 bit: from CD (9.07.01\MySQL\mysql-connector-odbc-3.51.14-win32.msi)
    2. For Windows 7 32 bit/64 bit from http://dev.mysql.com/get/Downloads/Connector-ODBC/5.2/mysql-connector-odbc-5.2.4-ansi-win32.msi/from/http://cdn.mysql.com/
      1. If above links are not working, please download respective driver from http://dev.mysql.com/downloads/connector/odbc/
  3. Run Extended List View Control Setup from CD (9.07.01\Generic Software\extlvctl.exe)
  4. Run HID VertX Discovery Client Setup from CD (9.07.01\HID\setup.exe)

Creating Database

For Windows XP SP2, you can use SnehapadmaDBTool.exe distributed with CD to create the database, and database users. In other cases, run script SPTOnCSSeed9.07.01.sql from Seed Database folder of CD using MySQL Query Browser as described in Database Activities.

Creating DSN for Time Office and CentralStation

For Windows XP SP2, you can use SnehapadmaDBTool.exe distributed with CD to create the DSNs automatically. Otherwise, use the following procedure:
  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

In case you face any dependency issues in Snehapadma TimeOffice related to OCX or DLL not found, please install Microsoft Visual Basic 6.0 Service Pack 6 Cumulative Update on your computer.
ċ
COMCT232.OCX
(160k)
Harshal Baviskar,
Jan 24, 2012, 2:51 AM
ċ
COMDLG32_Dependency_Error_Resolution.zip
(519k)
Harshal Baviskar,
Jan 24, 2012, 2:52 AM
ċ
SPTOnCSSeed9.07.01.sql
(265k)
Harshal Baviskar,
Dec 24, 2011, 12:55 AM
ċ
SnehapadmaCentralStation9.07.01-Client-mini.zip
(5119k)
Harshal Baviskar,
Nov 20, 2011, 8:15 PM
ċ
VBPowerPacks.zip
(434k)
Harshal Baviskar,
Mar 28, 2013, 10:26 PM
ċ
msstdfmt.dll
(126k)
Harshal Baviskar,
Apr 15, 2012, 7:25 PM
Comments