EMWAC Database Demonstrator - ODBC version Installation Notes

(Notes on using the demonstrator are in file readme2.txt)

The following notes refer to installation of the application to
interact with remote servers over TCP/IP.  If you cannot meet the
communications prerequisites then probably the Access Only
version would be a better bet to start on.

Software prerequisites
----------------------
The development was done under Windows for workgroups 3.11, 
Microsoft Access 1.1 and SQL Server ODBC version 1.01.  
Operation in other environments has not been tested.

Communication with the EMWAC server over Internet requires
Microsoft's TCP/IP to be installed. 

Hardware Requirements
---------------------
The machine used for development was an IBM 486 with 16mb RAM. 
The application should work however on any PC compatible capable
of supporting the software prerequisites.  8mb RAM is the
recommended minimum.  400k of disk memory is required to load the
application initially.  This will expand; how much depends on how
the application is used; 1 mb should generally be sufficient.

Installation
------------

1.   Application
     The Access database containing the applications is a normal
     Access database, contained in a single file and is named
     odbcc91p.mdb.  It can be installed (by copying it after
     uncompressing it) in any convenient directory.  

2.   ODBC data sources
     Using ODBC in the control panel (was not in the control
     panel in earlier versions of Windows), install the
     SQLSERVER driver. 

     Still in ODBC, define the following SQLSERVER data sources:

     Data source name:   censco91du
     Description:        Census, Scotland, 1991, Dummy data    
     Server:             Clyde.emwac.ed.ac.uk
     Database Name:      scsdummy

     Data source name:   censco91oa
     Description:        Census, Scotland, 1991, Output Areas  
     Server:             Clyde.emwac.ed.ac.uk
     Database Name:      sassco91oa

     Data source name:   censco91pc
     Description:        Census, Scotland, 1991, Postcode
                         Sectors
     Server:             Clyde.emwac.ed.ac.uk
     Database Name:      sassco91

     Data source name:   emwac
     Description:        Emwac DB project demonstrator control
                         database
     Server:             Clyde.emwac.ed.ac.uk
     Database Name:      dscontrol

4.   Verify that ODBC and your TCP/IP connections are working: 
     i.   start Access
     ii.  Define a new Access database
               NEW in the FILE menu; the database name is
               arbitrary.  The Access "Database" window should
               now appear.  The database will contain no tables.

     iii. Try attaching a table
               ATTACH TABLE...  in the FILE menu
                    The "Attach" window should appear
               Data Source: <sql database>
                    The SQL Data Sources window should appear
               SQL Data Sources: emwac
                    The SQL Server Login window should appear
               Login id: Guest
               Password:   (no password, just press return)
                    The Attach Tables window should appear
               Choose erds08.tables_table and press Attach 
                    The "Successfully Attached" should appear
               Click on OK to clear the message
               Click on Close to clear the Attach Tables window
                    The table named "erds08_tables_table" should
                    now be in the Access database window.  The
                    arrow marker against the table indicated
                    that it is an attached table

          d.   Verify you can open the table
               The table's datasheet should appear.

          e.   Exit the table's datasheet

          f.   "delete" the attached table.  by selecting it and
               pressing the delete key.

     iv.  close the temporary Access database you created.

     v.   Delete the temporary Access database you created.  It
          is a single file with the name xxxxx.mdb - where xxxxx
          is the arbitrary name you assigned to it.

5.   If all the above worked, you are now ready to start your
     application.  If you failed to attach a table, then there
     is no point in starting your application as it cannot work
     successfully with remote tables.  Either work on getting
     tables to attach successfully or use the Access database
     version of the application.


User Ids and Passwords
----------------------

A login id and password is required when Access logs on to a
server. 

The login id of Guest, with a null password (that is no
characters typed)  should be used for the data sources censco91du
and emwac Live census data (that is the data sources censco91oa
and censco91pc) is all password protected; it is not accessible
unless you have an undertaking with an appropriate disseminator
(e.g. the Data Library, University of Edinburgh or the Census
Microdata Unit, University of Manchester).  If you wish to access
live census data through this demonstrator application, contact
the Data Library, University of Edinburgh, 38 George Square,
Edinburgh EH8 9LJ who will arrange for a user number and password
to be allocated.

Note when accessing live Census data as an authorised user: 
     i.   the application will ask you for a password every time
          it attached a table.  This is to avoid storing
          passwords locally.
     ii.  when accessing live census data, the application will 
          occasionally require data from its control data source
          "emwac".  You should use a user-id of Guest with a
          null password when accessing that data source.