|
|
|
ColdFusion
Allaire ColdFusion is a
popular web applications development tool. ColdFusion uses a tag-based, server
scripting language that is ideal for programming Web applications. Processed
entirely on the server, the ColdFusion Markup Language (CFML) cleanly
integrates with HTML for user interface and XML for data exchange. Both open
and extendible, CFML supports more than 70 server-side tags, 200 functions, and
800 third-party components making it the most productive language available for
creating advanced Web applications. In addition, ColdFusion supports Java and
C++, and fully integrates with object transaction middleware through COM,
CORBA, or EJB.
ColdFusion is commonly used for the development of database-enabled web sites, and supports several databases including dBase/FoxPro, IBM DB2/6000, INFORMIX 7.x/9.x, Sybase 11, OpenIngres 1.x/2.x, Oracle 7/8, MS SQL, and MySQL. Though ColdFusion is capable of connecting to all these databases, MySQL is the only database, which can be run on your Virtual Server.
Installation
ColdFusion 4.5 can be added to your Solaris Virtual Server via the Order Form or after ordering by emailing
support@alts.net.
ColdFusion and MySQL
ColdFusion comes with the ability to connect via ODBC to a MySQL database. This allows you to
create a dynamic link between your Web site and MySQL. How is that done? Follow
the instructions below.
Open your Web browser, and connect to:
http://YOUR-DOMAIN.NAME/cfide/administrator
Enter your password in the Password text box.
The ColdFusion Administrator page will be launched.
On the left menu bar, under data sources, click ODBC. The ODBC Data Sources Available to ColdFusion page will be displayed.
To add a mySQL database, enter the data source name in the Data Source Name text box. The data source name can be any of your choice.
In the ODBC Drivers drop down box choose, myODBC mySQL Driver.
Click the Add button to add the ODBC driver.
The Create ODBC Data Source [myODBC mySQL Driver] page will appear. This is where you will set the settings to connect to your database.
The Data Source Name text box should already be filled out with the name you gave earlier.
The Description text box is where you can give a brief description of the database connection.
The Database Name text box is for the name of the database you are connecting to.
The Server Host Name text box is where you will need to provide the name of the server that your database is on. If your database is on the same server, than use the default Local Host.
The Server Port text box should remain 3306. If your database is on a different server and you know the port number, then make the necessary changes to the correct port.
Click the CF Settings button.
A new screen will appear with some additional information.
The Username and Password text boxes are where you set the Username and Password for your mySQL database.
Click the Create button to add the connection.
The ODBC Data Sources Available to ColdFusion screen will appear. On the right-side of the screen there should be a Verified next to the Data source you just added.
More Information
For more information, refer to the following sites and documents.
Copyright © 1996-2001 A Little Technology Shoppe, LLC
(ALTS.NET®). All rights reserved. All trademarks are owned by the
respective company or A Little Technology Shoppe, LLC.
Last modified: 16 January 2001.