JSC403

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)

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.

Database Options

• Microsoft Access 2000 or later
• Microsoft SQL Server 2005 Express
  • Download
• MySQL 4.1 or later
  • Download
• Oracle 8i or later
  • Download - - Oracle Database 10g Express Edition
  • The file you want to download is Oracle Database 10g Express Edition (Western European) - OracleXE.exe.
  • You will need to register for a free account.
  • Run through the Installer accepting all the defaults. Make sure to write down your password.
  • Follow steps 1-3 of the Getting Started Guide available at the Oracle 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.

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.

Setup Instructions

1. Create a folder in the root of your C:\Inetpub\wwwroot directory called "Webucator" and extract the class files zip to that folder.

Firebug for Firefox

• Get Firebug

Using Firebug with Ajax

We strongly recommend getting Firebug when taking any of our Ajax courses because you can:

• See the Ajax calls being made to the server and what parameters, if any, were passed.
• See the response from the server after the Ajax calls are made in either plain text, JSON, or XML accordingly.
• Inspect HTML elements
• Learn more...

Databases

Using MySQL

There are MySQL database scripts in the ClassFiles/Setup directory. Open and execute them in your MySQL client software.

Using Access

There are Access databases in the ClassFiles/Setup directory. You must have Microsoft Access installed to use them for this class.

Database Access in 64-bit Windows

The first option is to use MySQL instead of the Access files. Since this does not use ODBC.

To use the Access files with ODBC, if you do not have a 64-bit MS Office installation:

1. You need to have a 32-bit Java installation which would generally be in C:\Program Files (x86) and therefore you will also need a 32-bit tomcat installation
2. Set a JAVA_HOME environment variable as discussed in the setup instructions and do the same for CATALINA_HOME (It is generally better to use the 8.3 form of paths that would have spaces, as in: C:\Progra~2\Java\jdk1.6.0_20 in which the ~2 is there because C:\Progra~1 is going to be C:\Program Files).

• You can test if the path is correct when written that way by pasting into the address bar of Windows Explorer.
• Go to c:\windows\SysWOW64. Find and double-click odbcad32.exe - that opens the 32-bit ODBC administrator

Data Source Names

Create three data source names: "Northwind", "Presidents", "DragDrop" that map to the databases of the same names in c:\Inetpub\wwwroot\Webucator\ClassFiles.

Testing The Setup

1. In your browser navigate to http://localhost/Webucator/ClassFiles/MoreAjaxApps/Solutions/Presidents.asp. You should see a table of the presidents.
2. Click once on the word "Washington" in the first row. It should become editable in a form field.
3. Modify the word (e.g, change it to "Washington2") and click the little edit icon next to it. It should blink and then show the new word.
4. Refresh the page. Your change should be shown.