Required Software:
==================

IE5 on client (except for certain files as indicated below)
IIS 4 or 5 and IE5 on server
ADO 2.5 on server
ADO 2.5 and VB6 on client machine for adotest.vbp/exe application
RDS 2.5 on client for authorviewer.asp

Configuration
=============

1. Copy all ASP, XSL, MDB, and UDL files to a directory on a Web server and configure that directory as Web root /vbpjado25
2. Copy VB source code to a client machine which has http access to web server used in step 1.  Note: client and server machines can be the same PC.
3. Double click the file pubsmdb.udl and change the database location to point to where you physically installed pubs.mdb in step 1.  If you installed it in c:\inetpub\wwwroot\vbpjado25, then this step is not necessary.
4. In the VB source code, in frmADO25Test, Sub cmdGetDataClick(), change the URL in rs.Open to point to your Web server, if other than http://localhost.  Recompile if desired.


Files and Descriptions:
=======================

recordsetxml.asp:
returns all data from authors table as XML

authorsrecordsetxml.asp:
Returns data from authors table as XML where au_fname like Request("txtlNamePattern")
e.g. navigating to http://server/vbpjado25/authorsrecordsetxml.asp?txtlNamePattern=B returns all records from authors table where au_lname LIKE 'B%'

authorsrecordsethtml.asp:
Returns data from authors table as HTML where au_fname like Request("txtlNamePattern")
e.g. navigating to http://server/vbpjado25/authorsrecordsethtml.asp?txtlNamePattern=B returns all records from authors table where au_lname LIKE 'B%'
Should work with IE or Netscape 3.x+ (tested only in Netscape 4 and IE 5)

genericrecordsetxml.asp:
Executes query Request("txtSQL") on connection Request("txtCON") and returns data as XML
e.g. navigating to http://server/vbpjado25/genericrecordsetxml.asp?txtSQL=select * from authors&txtCON=dsn=pubsmdb; returns all data from query "select * from authors" from database pointed to by connectstring "dsn=pubsmdb"

XMLEM.asp :
DHTML front-end for genericrecordsetxml.asp

recordsetxml.xsl:
used for XML formatting by all of the above ASP files

pubs.mdb
Access 97/Jet 3.5 database containing authors table from SQL Server pubs database

pubsmdb.udl:
OLE DB Datalink file used by all of the above ASP files (points to pubs.mdb)

authorsviewer.asp:
RDS-based front-end for authorsrecordsetxml.asp; should work in IE 4+ (only tested in IE5)

ado25test.vbp/exe, frmado25test.frm:
Source code and executable for VB6 front-end to authorsrecordsetxml.asp
