PDF HTML FlashPaper

ASP201

Contents

  • 1 Technical Requirements
    • 1.1 Operating System Options
    • 1.2 Microsoft Internet Information Services (IIS)
      • 1.2.1 Install IIS on Windows XP
      • 1.2.2 Install IIS on Windows Vista
      • 1.2.3 Install IIS on Windows 7
    • 1.3 Microsoft Access 2000 or later
    • 1.4 Using Classic ASP with Microsoft Access Databases on IIS 7.0 and IIS 7.5
    • 1.5 Any Text or HTML Editor
    • 1.6 Browser Options for Windows
  • 2 Class Files
  • 3 FAQS
    • 3.1 Why do I get this error when inserting or updating a record in the database: "Operation must use an updateable query" when using IIS6?

Technical Requirements

Operating System Options

This class only supports Windows Operating Systems.

  • Windows XP Service Pack 2 or above
  • Windows Vista
  • Windows 7

Microsoft Internet Information Services (IIS)

Note: IIS cannot be installed on Windows XP Home Edition.

Install IIS on Windows XP

To install IIS on Windows XP complete the following steps.

  1. On the instructor computer, click Start, and then click Control Panel.
  2. In Control Panel, if Control Panel is configured for Classic View, double-click Add or Remove Programs. If it is configured for Category View, click Add or Remove Programs.
  3. In the Add or Remove Programs window, click Add/Remove Windows Components.
  4. In the Windows Components Wizard, click Internet Information Services (IIS), and then click Details.
  5. In the Subcomponents of Internet Information Services (IIS) list, select the World Wide Web Service check box, and then click OK.
  6. In the Windows Components Wizard, click Next. Provide the path to your Windows source location, if necessary.
  7. When the wizard has completed, click Finish.
  8. Close the Add or Remove Programs window, and then close Control Panel.

Install IIS on Windows Vista

To install IIS on Windows Vista complete the following steps:

  1. On the instructor computer, click Start, and then click Control Panel.
  2. In Control Panel, if Control Panel is configured for Classic View, double-click Programs and Features. If the Control Panel is configured for Control Panel Home view click Programs and then click Program and Features.
  3. In the Uninstall or change a program window click Turn Windows Features on or Off.
  4. In the User Account Control dialog box click Continue.
  5. In the Windows Features dialog box expand Internet Information Services.
  6. Select World Wide Web Services check box and then click OK.
  7. Provide the path to your Windows sources location if necessary.
  8. Close Control Panel.

Install IIS on Windows 7

To install IIS on Windows 7 complete the following steps:

  1. Click Start >Control Panel >Programs
  2. Then click on the link in the left "Turn Windows features on or off"
  3. Check "Internet Information Services" along with the additional features: ASP, Request Filtering, and ISAPI Extensions.
  4. Click OK and browse to http://localhost
  • You should see the default IIS Welcome page.

Microsoft Access 2000 or later

  • If you do not have Microsoft Access, you can download a free trial of Microsoft Office Professional, which includes Access, from the Microsoft Web site.

Using Classic ASP with Microsoft Access Databases on IIS 7.0 and IIS 7.5

If you are using IIS7, you will need to do a little work to get your Access database working. There is a good article on this here. If you are using 64-bit Windows, pay particular attention to the "Working with 64-bit Systems" section.

Any Text or HTML Editor

If you don't already have something to use for Plain Text editing or Web authoring, please choose one of the options listed below.

  • Notepad is fine for class and is usually included with Windows.
  • Crimson Editor - Download
  • Adobe Dreamweaver - Download

Browser Options for Windows

  • Mozilla Firefox 2.0 or greater - Download
  • Internet Explorer 6 or greater - Download
  • Google Chrome - Download

Class Files

  1. Download the class files.
  2. After downloading the class files, create a directory on your hard drive named "Webucator" that can be found easily.
    1. On Windows it is recommended the new folder have a path of C:\Webucator.*
    2. On Mac OS X a good location for the new folder may be in your Documents directory.
  3. Extract the files to the folder you just created.
* If you are using XAMPP (e.g, for PHP classes), you must place the Webucator folder to the C:\xampp\htdocs folder.

FAQS

Why do I get this error when inserting or updating a record in the database: "Operation must use an updateable query" when using IIS6?

This error is usually due to inadequate permission on the database or the folder the database is in. Here is what you need to do:

  1. On your desktop, right-click on the Computer (may also be called "My Computer" icon and select "Manage".
  2. On the left, expand "Services and Applications", "Internet Information Services (IIS) Manager", "Default Web Sites"
  3. Right-click on the class files folder (e.g, ASP10a, ASP10b, ASP101, or ASP102) and select "Properties".
  4. Make sure Read, Write, and Directory Browsing are checked.
  5. Close out of Computer Management
  6. In Windows Explorer, navigate to C:\InetPub\wwwroot.
  7. Right-click on the class files folder (e.g, ASP10a, ASP10b, ASP101, or ASP102).
  8. Make sure Read-Only is NOT checked.
  9. Click on the Security tab
  10. Select IIS_IUSRS and give it Full Control.
  11. Close the properties window.

Note: If you cannot locate the security tab follow the steps below:

  1. Go to the control panel.
  2. Select folder properties
  3. Click on the view tab
  4. Ensure "Use Simple File Sharing" is unchecked

  • Instructor-led Online Classes
  • My Classes
  • Class Requirements
  • Setup Support
  • Class Setup Policy
  • FAQs

  • Onsite Classes
  • Class Info

  • Wiki Navigation
  • Login