• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Using Databases > How to Connect to Databases

How to Connect to Databases

To access a database using ColdFusion, you need a defined data source. A data source is a named configuration (driver and settings) that points to a specific database. The database can be located on the same server as ColdFusion or on another server elsewhere in the network.

The connection behind the data source acts as a gateway or translator to the database that is servicing the application. Each database has its own particular format and mechanisms for storing and retrieving data. To make application development easier, a data source is defined using a database driver (software that knows how to talk to a specific database). A driver and associated configuration is known as a data source. Database connectivity in ColdFusion is possible through JDBC. The included JDBC drivers allow developers to pass Structured Query Language (SQL) statements to databases and retrieve results (if appropriate).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint