HOW TO :
INSTALL ON SERVER
------------------
1. INSTALL MYSQL
2. CLICK MY COMPUTER > C:/mysql/bin/winmysqladmin.exe
4. IF REQUESTED FOR USERNAME & PASSWORD, KEYIN root AS USERNAME, 01011980 AS
PASSWORD, CLICK OK
3. RESTART PC
4. INSTALL MYSQL-FRONT 2.5
5. AFTER INSTALL, RUN MYSQL-FRONT, KEYIN IP = LOCALHOST, USER = root, LEAVE THE
PASSWORD BLANK ! AND CLICK CONNECT
6. GO TO [TOOLS] > [USER MANAGER]
7. CLICK TAB [EDIT USERS]
8. CLICK AT root@localhost, THEN CLICK BUTTON [EDIT USER...]
9. PUT IN PASSWORD = 01011980, CLICK [SAVE]
10. STILL IN THE [EDIT USERS] TAB, CLICK TO root@%, THEN CLICK BUTTON [EDIT
USER...]
11. PUT IN PASSWORD = 01011980, CLICK [SAVE]
12. EXIT MYSQL-FRONT
13. RE OPEN MYSQL-FRONT, THIS TIME, INSERT PASSWORD = 01011980, USER = root
14. IF U CAN ACCESS THE DATABASE, MEANS THAT THE USER SETUP IS SUCCESSFULL.
15. EXIT MYSQL-FRONT
16. DOUBLE CLICK FILE Hopetech.sql
17. MYSQL-FRONT WILL RUN...
18. KEYIN USER= root, PWD = 01011980
19. RIGHT CLICK AT A COLUMN ON YOUR LEFT-HAND SIDE, CHOOSE "Create Database"
20. CREATE A DATABASE NAME = Hopetech
21. HIGHLIGHT THE NEWLY CREATED DATABASE
22. CLICK AT TAB [QUERY]
23. U'LL NOTICE LINES OF SQL COMMANDS.
24. NOW CLICK AT EXECUTE BUTTON (The "Play" button look-alike)
25. MYSQL-FRONT WILL AUTOMATICALLY RUNS THE SQL COMMANDS
26. CLICK [REFRESH] BUTTON (OR JUST SIMPLY PRESS THE F5)
27. NOW THE DATABASE HAS BEEN SUCCESFULLY CREATED. CONGRATS......
28. INSTALL MYODBC
29. CLICK CONTROL PANEL > ADMIN TOOLS > DATA SOURCES
30. CLICK TAB [SYSTEM DSN]
31. CLICK BUTTON [ADD]
32. CHOOSE MYSQL ODBC DRIVER
33. DATASOURCE NAME = Hopetech, SERVER = -keyin ur server's ip- , USER = root, PWD
= 01011980, DATABASE = Hopetech
34. CLICK [TEST], IF SUCCESS, THE ODBC SETUP IS OK
35. CLICK OK
36. RUN THE EDRIVING SETUP PROVIDED.
37. CHANGE THE INSTALLATION PATH TO "C:/E-DRIVING" <-THIS STEP IS VERY
IMPORTANT.MAKE SURE U CHANGE THE INSTALLATION DIRECTORY.
38. MAKE SURE THERE'S FILES NAMED "PIMACTC.INI" IN C:/WINDOWS DIRECTORY, IF THERE'S
NO SUCH FILE, PASTE THE FILE THAT WERE PROVIDED WITH THE INSTALLATION DISK.
39. DOUBLE CLICK AT "SETTINGS.INI" LOCATED UNDER FOLDER "E-DRIVING" AND CHANGE THE
SERVER VALUE TO THE SERVER'S IP
39. CHANGE TIME & DATE TO hh:mm:ss AND dd/mm/yyyy
40. COPY AND PASTE FOLDER NAMED "ServerTime" PROVIDED IN THE INSTALLATION DISK INTO
C:/. AFTER THE FOLDER IS PASTED, OPEN THE FOLDER.
41. RIGHT CLICK ON "Time.exe" AND CHOOSE "Create Shortcut".
42. A NEW SHORTCUT, NAMED "Shortcut to Time" WILL BE CREATED
43. RIGHT CLICK ON "Shortcut to Time" AND CHOOSE "CUt".
44. NOW CLICK AT WINDOWS <START> BUTTON, GO TO <PROGRAMS>, AND RIGHT CLICK ON
"Startup", AND CHOOSE "Open All Users".
45. NOW PASTE THE SHORTCUT THAT WERE CUT EARLIER ONTO THE WINDOW THAT APPEAR AFTER
U CHOOSE THE "Open All Users" CONTEXT MENU.
46. OPEN "MY COMPUTER", RIGHT CLICK ON C:/ CHOOSE "SHARING". SHARE THE DRIVE AS
"C".
47. UNDER C:/, CREATE FOLDER NAMED "TRANS"
48. COPY AND PASTE FOLDER NAMED "Attachment Generator" PROVIDED IN THE INSTALLATION
DISK INTO C:/. AFTER THE FOLDER IS PASTED, OPEN THE FOLDER.
49. DOUBLE CLICK AT "Attachment_setting.ini" LOCATED UNDER FOLDER "Attachment
Generator" AND CHANGE THE SERVER VALUE TO THE SERVER'S IP
40. RIGHT CLICK ON "AttachmentGenerator.exe" AND CHOOSE "Create Shortcut".
51. A NEW SHORTCUT, NAMED "Shortcut to AttachmentGenerator" WILL BE CREATED
52. RIGHT CLICK ON "Shortcut to AttachmentGenerator" AND CHOOSE "CUt".
53. NOW CLICK AT WINDOWS <START> BUTTON, GO TO <PROGRAMS>, AND RIGHT CLICK ON
"Startup", AND CHOOSE "Open All Users".
54. NOW PASTE THE SHORTCUT THAT WERE CUT EARLIER ONTO THE WINDOW THAT APPEAR AFTER
U CHOOSE THE "Open All Users" CONTEXT MENU.
55. COPY AND PASTE FOLDER NAMED "Email Sending" PROVIDED IN THE INSTALLATION DISK
INTO C:/. AFTER THE FOLDER IS PASTED, OPEN THE FOLDER.
56. DOUBLE CLICK AT "Email_setting.ini" LOCATED UNDER FOLDER "Email Sending" AND
CHANGE THE SERVER VALUE TO THE SERVER'S IP
57. OPEN CONTROL PANEL -> SCHEDULED TASK
58. CLICK "Add Scheduled Task"
59. BROWSE TO "C:/Email Sending" AND CHOOSE "HopetechMailClient.exe".
60. CHOOSE "Daily".
61. START TIME = "14:00"
62. FOLLOW UNTILL FINISH.
63. RUN E-DRIVING AND TEST
64. OK.. FINISH WITH SERVER.
INSTALL ON CLIENT
-----------------
1. INSTALL MYODBC
2. CLICK CONTROL PANEL > ADMIN TOOLS > DATA SOURCES
3. CLICK TAB [SYSTEM DSN]
4. CLICK BUTTON [ADD]
5. CHOOSE MYSQL ODBC DRIVER
6. DATASOURCE NAME = Hopetech, SERVER = -keyin ur server's ip- , USER = root, PWD =
01011980, DATABASE = Hopetech
7. CLICK [TEST], IF SUCCESS, THE ODBC SETUP IS OK
8. CLICK OK
9. RUN THE EDRIVING SETUP PROVIDED.
10. CHANGE THE INSTALLATION PATH TO "C:/E-DRIVING" <-THIS STEP IS VERY
IMPORTANT.MAKE SURE U CHANGE THE INSTALLATION DIRECTORY.
11. MAKE SURE THERE'S FILES NAMED "PIMACTC.INI" IN C:/WINDOWS DIRECTORY, IF THERE'S
NO SUCH FILE, PASTE THE FILE THAT WERE PROVIDED WITH THE INSTALLATION DISK.
12. DOUBLE CLICK AT "SETTINGS.INI" LOCATED UNDER FOLDER "E-DRIVING" AND CHANGE THE
SERVER VALUE TO THE SERVER'S IP
13. CHANGE TIME & DATE TO hh:mm:ss AND dd/mm/yyyy
14. CLICK CONTROL PANEL > PRINTER
15. CHOOSE THE DEFAULT PRINTER AND MAKE SURE THAT THE PAPER IS SET TO LETTER
16. DOUBLE CLICK AT "SETTINGS.INI" LOCATED UNDER FOLDER E-DRIVING AND CHANGE THE
SERVER VALUE TO THE SERVER'S IP
17. RUN E-DRIVING AND TEST
18. OK.. FINISH WITH CLIENT. AND YOUR EDRIVING SOFTWARE IS READY FOR ACTION.
PREPARED BY :
MUHAMAD NASRON
PROGRAMMER
HOPETECH SPPIM SDN BHD
