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

Lesson 13. Connecting to Data Sources > Understanding Data Source Names

Understanding Data Source Names

As you may recall from Lessons 6 and 7, where you created a simulation in which users created DSNs on Windows machines, a DSN is used to help a server running ColdFusion, ASP, and the like to connect to a data source. (If you want a quick review, open sim_dsn.swf in Lesson 7's Complete folder on the CD-ROM.) Specifically, a DSN specifies a driver (which enables ColdFusion to communicate with the specific data source you are using, such as a Microsoft Access or SQL Server database) and a path, which tells ColdFusion where to find the data source.

Now, individual pages can interact with the data source (in this project, a Microsoft Access database) differently. One page might insert new records into the database. Another page might retrieve and display information from the database. Yet another might retrieve and enable the user to edit the information or delete it. Because each page potentially uses the database in a different way, specific directions for interacting with the database occur on each page.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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