CFM501

Technical Requirements

Operating System Options

• Windows XP Service Pack 2
• Windows Vista
• Windows 7
• Mac OS X

ColdFusion Application Server

• Download - You may need to register.
• System Requirements
• Select the 32 bit edition if you are using Access as the database. (Even if you are running a 64 bit OS, you must run the 32 bit edition to use Access

Installation

Choose the default options during the installation, with the following exceptions:

• Step 3, Install Type: 'Developer Edition'
• Step 4, Install Configuration: 'Server Configuration'
• Step 10, Configure Web Servers: choose 'Built-in Web Server'.
• When asked to enable RDS select Yes and set a password

If you have access to a networked or remote server with ColdFusion 8 or 9 and Microsoft Access, that will also work. In this case, you will need to be able to access ColdFusion Administrator to create Data Source names.

Database Choice

• Access (recommended) – You do not need to have Access on your system. ColdFusion includes the drivers for many databases. Note: Even if you are running a 64 bit OS, you must run the 32 bit ColdFusion in order to use Access.

OR

• Any other database of your choice

NOTE: Most students find it easiest to use Access, but many databases are supported by ColdFusion. You may import the Access database into any other database of your choice and set up a DSN named “movieList.”

Adobe Dreamweaver CS5

• Download - You may need to register.

Browser

At least one of the following browsers.

Browsers for Windows

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

Browsers for Mac OS X

• Mozilla Firefox 2.0 or greater - Download
• Safari 3.0 or greater - Download

ClassFiles

Download the class files.

1.Create a folder your web root directory called "Webucator" and extract the class files zip into that folder. Your web root is the default directory that your web server will use.

1. Windows: This is usually located in C:\ColdFusion8\wwwroot if you are using the built-in web server, or C:\Inetpub\wwwroot if you are using IIS.
2. Macintosh: This is usually located in Applications/ColdFusion9/wwwwroot if you are using the built-in web server, or /Library/WebServer if you are using Apache. If you are using apache, the configuration file is located at /etc/apache2/httpd.conf and is stated on the line that starts with "DocumentRoot"

2.Create a data source in ColdFusion administrator called "movieList" that points to the runners.mdb Access file in the data directory

1. There is a good tutorial on this at http://www.quackit.com/coldfusion/tutorial/coldfusion_datasource.cfm. If you're taking an live online class, your instructor will walk you through it in class.
2. Open your browser to http://localhost/CFIDE/Administrator/ (or http://localhost:8500 or http://localhost:3500 if using the Built-in web server).
3. Log in using the password you provided during the installation.
4. Click on 'Data Sources' in the left-hand menu, under the heading 'Data & Services'
5. If you are using Access: Enter the Data Source Name as 'movieList', select the Microsoft Access Driver, and click 'Add'. Enter the path location to the runners.mdb file in the ClassFiles/Setup directory in the Database File field. This path is most likely C:\ColdFusion8\wwwroot\Webucator\data\movieList.mdb if you are using the built-in web server on Windows, or /Application/ColdFusion8/wwwroot/Webucator/data/movieList.mdb

FAQ

• If you choose to use the ColdFusion built-in web server as one of the options during the install (recommended unless already running Apache or IIS), you will need to use the port as specified on line 350 of the jrun.xml file (usually 3500 or 8500) that is located at "C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\jrun.xml". To test the setup, open the browser to http://localhost:8500/Webucator/... replacing "8500" with the appropriate port number.