There are two possible types of database connections involved when creating and testing dynamic database-driven web pages in Macromedia Dreamweaver MX: (1) the design-time connection and (2) the run-time connection. This TechNote addresses the question of the difference between the two connections and when and where they should be used.
Understanding Design-Time and Run-Time Connections in Dreamweaver