Active Server Pages code samples

DBASE.ASP (stored as DBASE.TXT so our web server won't try to run it as a script) - This script takes a database name as a parameter, and looks up the record for the database in the RefDatabases.mdb file using an ODBC connection. Information from RefDatabases.mdb and the user's IP address is used to:

• Log usage for statistical report
• Construct a URL for accessing the resource
• Route user through the EZproxy URL-rewriter if necessary

bySubject.ASP (stored as bySubject.txt) - This script takes a subject area code and optional access level (All users vs Grad Students/Faculty/Staff) as parameters, then pulls data from RefDatabases.mdb to construct a page of electronic resources available in a given subject area. It also can be set to build subject-specific HOME.HTML pages for Web2 Z39.50 searching. To see what it does, go to: http://libnt1.is.tcu.edu/www/Online/SubjectList.asp and click on any of the large subject headings.

RefDatabases.mdb - Database we use to keep track of Web and CD-ROM databases, used by the scripts above. Contains information on the URL needed to access the resource, which group of users should be granted access, and whether or not the database requires a connection through EZproxy for off-campus access (or for all access in the case of databases using username/password validation).