Blue Reef Technical Support ResellersAbout Blue Reef Consulting, Inc.

EcommerceSearch
Return to Blue Reef Virtual Servers Home Page
Order virtual servers, software, computers, and more!
Return to Blue Reef Main Home Page
Specials
Site Map
Database solutions for your Virtual Server.



Virtual Servers Home Page
Virtual Server Support
Virtual Server Addons
Database Solutions
Database Overview
mSQL Overview
mSQL and MS Access
mSQL and W3-msql
mySQL Overview
MySQL and MS AccessMySQL and MS Access
MySQL and ColdFusionMySQL and ColdFusion
PostreSQL Overview
Request help using our Problem Tracking System
Order a Blue Reef Virtual Server now!


ColdFusion and MySQL

ColdFusion allows you to connect to a MySQL database via ODBC. This allows you to create a dynamic link between your Web site and MySQL. How is that done? Follow the instructions below.
  1. Open your Web browser, and connect to:
    http://yourdomain.com/cfide/administrator
  2. Enter your password in the Password text box.

  3. The ColdFusion Administrator page will be launched.

  4. On the left menu bar, under data sources, click ODBC. The ODBC Data Sources Available to ColdFusion page will be displayed.

  5. 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.

  6. In the ODBC Drivers drop down box choose, myODBC mySQL Driver.

  7. Click the Add button to add the ODBC driver.

  8. The Create ODBC Data Source [myODBC mySQL Driver] page will appear. This is where you will set the settings to connect to your database.

  9. The Data Source Name text box should already be filled out with the name you gave earlier.

  10. The Description text box is where you can give a brief description of the database connection.

  11. The Database Name text box is for the name of the database you are connecting to.

  12. 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.

  13. 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.


  14. Click the CF Settings button.

  15. A new screen will appear with some additional information.

  16. The Username and Password text boxes are where you set the Username and Password for your mySQL database.

  17. Click the Create button to add the connection.

  18. 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.
NOTE: MySQL databases need to be in ALL CAPS in order for them to work properly with ColdFusion. See also:

Allaire Knowledge Base: 'Unknown Connection' Error When Connecting to MySQL Databases Using ODBC
SEE ALSO:

PHP3 Development


mSQL User's Guide

mySQL User's Guide

PostgreSQL User's Guide

CGI Scriptorium

Server Add-ons

BOOKS TO HELP YOU:

MySQL (OTHER NEW RIDERS)
MySQL (OTHER NEW RIDERS)


The Data Webhouse Toolkit
The Data Webhouse Toolkit : Building the Web-Enabled Data Warehouse

Amazon.com logo
Search for :
Enter keywords...