Auction Demo Installation

This page describes how to set up the Auction demo on your Web server.

System Requirements

  1. Web Server

    You must have Active Server Pages (ASP) running on your server to run the Auction demo. You can use Internet Information Server 3.0 Non-SBN link or later, or Personal Web Server Non-SBN link.

    For Personal Web Server, you must enable 'Execute' permissions in the directory containing the demo. Do this by checking the 'Execute' checkbox in the properties pane under PWS Administration.

  2. Database

    The demo will work with either a Microsoft Access or a SQL Server database. No special setup is required to use the Microsoft Access version (although you must have Microsoft Access 97 installed on your system). Directions for SQL Server are provided below.

    SQL Server

    For SQL Server, you need to use the following files provided in the auction/database folder:

    • auction_tables.sql - A setup script for SQL Server.
    • item_table.dat - Data file for the items table.

    Before running the script, you'll need to create a database on your system by following these instructions:

    1. Run the SQL Enterprise Manager.
    2. Create a new database on your server called "Auction".
    3. Under the database options, select the "Select Into/Bulk Copy" option. This is required to load the data from the backup files.
    4. Under the Tools menu of Enterprise Manager, start the SQL Query Tool.
    5. Click the Icon to open a file.
    6. Select the auction_tables.sql file.
    7. Click on the "Execute Query" button (the right-hand arrow). The tables are now created.
    8. Create a new backup device for the Auction database.
    9. Right click on it and select "Restore".
    10. Select the new backup device in the list of "Devices and Files".
    11. Click the "From Device..." button on the right side of the Restore dialog.
    12. Click the "Add File..." button on the right side of the Restore from Device dialog.
    13. In the Add Backup Disk File dialog, enter the full path to: item_table.dat.
    14. Click the "OK" button.
    15. Select the file you just added in the list of "Devices and Files".
    16. Now click the "Restore Now" button on the Restore from Device dialog.
    17. Bring up the admin.htm page via your web server and select the Reset Database button.
    18. Your database is now ready to use with the Auction demo.

    Access

    An Access database auction.mdb is provided in the auction database folder. The only other thing you need to set up is the ODBC DSN, as follows.

  3. ODBC DSN

    Use the ODBC Control Panel to create a new System DSN with the name "Auction" that points to the Auction database.

    SQL Server Directions:

    Exact directions will differ depending on the version of ODBC installed on your system. The following notes should help you to set the options appropriately:

    1. Select SQL Server as the ODBC driver type.
    2. Set the Server parameter to the name of the machine with SQL Server.
    3. If prompted, select login using the ODBC parameters, NOT the Windows NT domain login.
    4. Set the default database to be used with the DSN to the 'Auction' database.

    Access Directions

    Again, exact steps to take will differ depending upon the version of ODBC installed on your system. The following notes should help you set the options appropriately:

    1. Select Access as the ODBC driver type.
    2. Select the auction.mdb file installed with the XML distribution.
    3. Specify no password for access.

    Note: The demo assumes that no passwords are required for access. If you have a password on your system, you'll need to edit the ASP files to include the password.

Running the Demo

The demo requires Internet Explorer 4.0, which you can download from http://www.microsoft.com/ie/ie40/download/ Non-SBN link.

Once Internet Explorer 4.0 is installed, run the demo.htm file from your server.

Note: It is important that you access the demo from the server as opposed to directly viewing the page from the file location. The ASP pages used by components in the demo will not run successfully if referenced from a file URL.

HomeBack to the XML Parser home page.

© 1997 Microsoft Corporation. All rights reserved. Terms of use.