 |
Auction
Demo Installation
This
page describes how to set up the Auction demo on your Web
server.
System
Requirements
- 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 or
later, or Personal
Web Server .
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.
- 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:
- Run the
SQL Enterprise Manager.
- Create a
new database on your server called
"Auction".
- Under the
database options, select the "Select
Into/Bulk Copy" option. This is
required to load the data from the backup
files.
- Under the
Tools menu of Enterprise Manager, start
the SQL Query Tool.
- Click the
Icon to open a file.
- Select the
auction_tables.sql file.
- Click on
the "Execute Query" button (the
right-hand arrow). The tables are now
created.
- Create a
new backup device for the Auction
database.
- Right
click on it and select
"Restore".
- Select the
new backup device in the list of
"Devices and Files".
- Click the
"From Device..." button on the
right side of the Restore dialog.
- Click the
"Add File..." button on the
right side of the Restore from Device
dialog.
- In the Add
Backup Disk File dialog, enter the full
path to: item_table.dat.
- Click the
"OK" button.
- Select the
file you just added in the list of
"Devices and Files".
- Now click
the "Restore Now" button on the
Restore from Device dialog.
- Bring up
the admin.htm page via your web
server and select the Reset Database
button.
- 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.
- 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:
- Select SQL
Server as the ODBC driver type.
- Set the
Server parameter to the name of the
machine with SQL Server.
- If
prompted, select login using the ODBC
parameters, NOT the Windows NT domain
login.
- 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:
- Select
Access as the ODBC driver type.
- Select the
auction.mdb file installed with the XML
distribution.
- 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/ .
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.
Back to the XML Parser
home page.
©
1997
Microsoft Corporation. All rights reserved. Terms of use.
|