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

Day 8. Defining a Dynamic Site > Database Connections

Database Connections

After you've defined your Web site using the appropriate server model, you can define a database connection. Several data access methods are supported by Dreamweaver MX—you will be guided by the program into choosing the right one for your server deployment platform:

Data Source NamesAs you learned yesterday, using the ODBC controls, you can “abstract” a database so that the server system references it by a simple name, called the data source name. Once the ODBC connection is installed, using the database in Dreamweaver MX becomes simple. Yesterday you set up all of the necessary DSNs for the MySQL and MS Access databases used in the book.

Connection Strings— Provide another means of specifying a data source name and pertinent connection information in the form of a text string. These are somewhat confusing to configure, but result in faster access to the database if an OLE DB provider is used rather than ODBC. If you're a beginner, you're probably better off avoiding this until later. OLE DB connections are available only on NT/2000/XP machines with MDAC 2.6.

JDBC— Java Database Connectivity. A fully cross-platform means by which a database can be queried. Much like the connection strings, setting up JDBC drivers involves entering a text string that can change depending on the type of database and JDBC driver you're using. Not difficult once you find the documentation, but sometimes it takes some digging.

ColdFusion Data SourcesA data source that has been defined in the ColdFusion administration package. This data source is specific to the ColdFusion model and is only used on the server connection.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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