Lab Outline Week 9

Bring Your 382 Project Folder to Lab

Bring your 382 project folder (including Access database) on a disc or diskette.

What you will do in lab

There are two ways to connect a dynamic web page to a database: A) use a DSN; and, B) use a connection-string ("Creating a DSN-less ODBC Connection").

Your GTF will show you how to use a connection string to in your ASPs.

Here’s an example of the syntax:
```
Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\inetpub\wwwroot\382mh\db\BigHit.mdb
```

Your GTF will show you how to install your project (using the above connection string) on 382net, which we will use as our remote server, i.e., production server.
Note that the category links in your site's navigation bar will have to be modified when your site is installed in C:\Inetpub\wwwroot\, which is IIS's default website folder.

URLs starting from the site root folder begin with a slash ( / ). The URL for a category link should start with the root folder and include the correct path to your product index: E.g., /382mh/asp-bin/products.asp?catID=1.