Download the Microsoft Access 95 version of the Botworks sample files (zipped, 1.6 MB). Please choose the appropriate option in your unzip utility to restore the directory structure.March 1996
This sample provides a fully functioning, order-entry Web site for a fictitious company called Machine Head Botworks. The site was designed to provide corporate developers with a solid foundation upon which to base their own Web sites.
The sample uses the new Internet database connector (HTTPODBC.DLL) to demonstrate how to build a database-enabled site linking to either Microsoft® Access 95 Jet 3.0 MDB or SQL Server 6.0 back ends. The site demonstrates how users can manage access to data and files and shows how a table-driven structure can be much easier to maintain than current, more traditional models.
To run this sample, you must have Microsoft Windows NT™ 3.51 with Service Pack 3 and Internet Information Server 1.0. The Microsoft Access version of the sample also requires Microsoft Access for Windows® 95, version 7.0, and the SQL Server version of the sample requires Microsoft SQL Server 6.0.
Download the Microsoft Access 95 version of the Botworks sample files (zipped, 1.6 MB). Please choose the appropriate option in your unzip utility to restore the directory structure.
Download the SQL Server version of the Botworks sample files (zipped, 1.6 MB). Please choose the appropriate option in your unzip utility to restore the directory structure.
Installation instructions:
1. Copy the BOTWORKS directory into the WWWROOT directory of your installation of Internet Information Server version 1.0.
2. Open the Control Panel and run the 32-bit ODBC applet.
3. Click System DSN.
4. Click Add.
For the Microsoft Access 95 version of Botworks:
5. Choose Microsoft Access Drive (*.mdb), and click OK.6. In the Data Source Name field, type "bot". You can type a description in the Description field.
7. Click Select and enter the absolute path to the BOTWORKS\DATA\MHB.MDB file.
8. Click OK, and click Close twice.
9. Close the Control Panel.
10. Skip ahead to 18.
For the SQL Server version of Botworks:
5. Choose SQL Server, and click OK.6. In the Data Source Name field, type "botSQL6". You can type a description in the Description field.
7. Click Options, and in the Database Name field, type MHB.
8. Click OK, and click Close twice.
9. Close the Control Panel.
10. Start ISQL/w.
11. Open the file WWWROOT\BOTWORKS\DATA\mhb_init.sql in your installation of IIS. This SQL Setup script will create a 5 MB database. Please note that it is set to create a Database Device called MHB and a Database called MHB. It is assumed that SQL Server is installed in C:\SQL60. Make modifications where necessary.
12. Click Execute Query to generate the SQL Database.
13. Once the database is generated, close ISQL/w.
14. Start Microsoft Access for Windows 95 and attach all of the tables using the botSQL6 DSN with their default names.
15. Click the Macro tab in the database container.
16. Double-click the macro mcrLoadDataToSQL. This will add the sample data into the new MHB SQL Server database.
17. Close Access.
18. Start Internet Information Server Manager.
19. Find your server on the tree and highlight the WWW Service Icon.
20. Choose Service Properties from the Properties menu.
21. Choose the Directory tab, and click Add.
22. In the Directory field, type or browse for the wwwroot\botworks directory in your installation of IIS.
23. In the Alias field, type "/botworks".
24. In the Access group, choose Select Only the Read checkbox, and click OK.
25. Click Add again.
26. In the Directory field, type or browse for the wwwroot\botworks\Images directory in your installation of IIS.
27. In the Alias field, type "/Images".
28. In the Access group, choose Select Only the Read checkbox, and click OK.
29. Click Add once again.
30. In the Directory field, type or browse for the wwwroot\botworks\Scripts directory in your installation of IIS.
31. In the Alias field, type "/botidc".
32. In the Access group, choose Select Only the Execute checkbox, and click OK.
33. From Windows 95 Internet Explorer 2.0, locate your home directory and add /botworks/activex.htm to the end. For example, if your server is named FatTuesday, type FatTuesday/botworks/activex.htm.