MACROMEDIA COLFUSION MX 7-GETTING STARTED BUILDING COLDFUSION..., Getting Started

Page: 53 / 152

Exercise 3: Configuring a database connection 53
To access the ColdFusion MX 7 Administrator:
•
Open a browser and go to one of the following URLs:
■
External web server users: http://localhost/CFIDE/administrator
■
Built-in web server users: http://localhost:8500/CFIDE/administrator
■
J2EE server users: http://localhost: portnumber /CFIDE/administrator. If you installed
ColdFusion Enterprise Edition with JRun, the default HTTP port is 8300.
Note: If you are accessing the ColdFusion MX Administrator from a remote client, you must replace
localhost with the host name or IP address of the computer where ColdFusion MX is installed.
The following sections describe how to establish a connection to the sample tutorial database file
and how to enable optional debugging settings.
Configuring the connection to the sample database file
The following procedures describe how to configure a connection to the sample database file
(CompassTravel) using the ColdFusion MX Administrator. Prior to building the sample
application, you must configure the Compass Travel database connection.
Perform one of the following procedures. The Microsoft Access procedure is for Windows users.
The PointBase procedure is for UNIX and Macintosh OS X users.
To define the connection to the sample Microsoft Access database:
1.
In the ColdFusion MX Administrator, select Data & Services > Data Sources.
2.
In the Data Source Name box, enter CompassTravel .
3.
In the Driver list, select Microsoft Access with Unicode.
4.
Click Add.
5.
Click Browse Server and navigate to the cf_root /cfdocs/getting_started/db/CompassTravel.mdb
file.
6.
Click Apply.
7.
Click Show Advanced Settings and ensure that the settings for CLOB and BLOB are enabled
(checked).
8.
Click Submit to complete the data source configuration.
The ColdFusion MX Administrator verifies the data source connection and the name
CompassTravel appears in the Connected Data Sources table.
9.
Ensure that OK appears in the Status column for CompassTravel.
If the connection to the CompassTravel data source fails, do the following:
a
Verify that the name of the data source file does not contain a space. If it does contain a
space, delete the data source from the Connected Data Source dialog box. To do this, click
the Delete action button associated with the CompassTravel data source name, and then
repeat the steps in this procedure to reconfigure this data source.
b
Verify that the path specified for the Compass Travel database file is correct.