SAM: Connecting to database server

The SAM backend databases reside on a server so that all SAM user's PCs can share the same data. This document describes how to accomplish this connection via mapping drive X:. Please follow the steps outlined on the right.
Some background on SAM design



That's it! Just to confirm all is well start SAM in the usual way: either double-click the SAM2 desktop icon (above) or select "Start Menu \ Programs \ SAM Schools Admin 2 \ SAM 2 Schools Admin.DB".

  1. Right-click on "Network Neighborhood", from the resulting context menu (shown on the left)...
  2. Select "Novell Map Network Drive" and click
  3. The Novell "Map Drive" window should appear(shown below, the exact labelling of the tick-boxes differs from version to version)...

  4. Select drive letter X: tab to...
  5. Enter \\MINOS\SAM in the "network path" field, tab to...
  6. Check (i.e. tick) the "top most level" (or "map root") box, tab to...
  7. Check the "always map" (or "reconnect at logon") box
  8. Press the Enter key -or- click the [Map] button...
  9. Confirm that the old mapping can be overwritten
  10. If SAM is being installed for the first time,
    skip the next instruction and see the section below
  11. Close the X: folder that will popup

SAM: Installing for the first time

  1. Open the X: drive folder either in Windows Explorer or My Computer
  2. Double-click the Program folder, ...
  3. Double-click the Sam2.exe application icon, ...
  4. Click [Unzip] (or press Enter) in the WinZip Self-Extractor window, ...
  5. When the files have been extracted, click [OK] (or press Enter) to remove the confirmation dialogue, ...
  6. Click [Close] (or press Enter) to finish.
There should now be a "SAM 2 Schools Admin.DB" icon on the desktop, and several items on "Start Menu \ Programs \ SAM Schools Admin 2". For subsequent installations of new releases of SAM use the "Setup SAM" item from that Start Menu.

If this is a new/fresh installation the application will need to know which School you are working with. In the "SAM New Installation" form enter your School's three character code in the School field, press the Enter key. The database path fields should be automatically filled-in and will normally not need to be modified. Click [Next] or (press Enter) and your front-end installation will be linked to the backend database tables which contain the data. The progress of the re-linking process can be monitored in the status field in the bottom left-hand corner of the MS-Access window. The re-linking can take several minutes, but will not need to be done again until a new release is installed.

If you encounter any problems please give Ray Burnley a call on x3300 or email R.D.Burnley@exeter.ac.uk.


Last updated 28-Aug-2001 .. Comments & questions to R.D.Burnley@exeter.ac.uk