What are design-time and run-time connections?
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. You use the design-time connection when working inside of Dreamweaver MX creating recordsets and applying server behaviors. You use the run-time connection when testing a completed dynamic page in a web browser or in the Dreamweaver MX Live Data mode.
Having separate design-time and run-time connections can oftentimes solve database connection errors within Dreamweaver MX. Separate connections can also usually speed up development time when working in Dreamweaver MX. When using separate design-time and run-time connections, the design-time connection will use a local database driver, a local DSN, and/or a local copy of the database, installed on the same machine that Dreamweaver MX is installed on. The run-time connection will use the driver and database on the testing server, which is also most likely your production server.
When should you use a separate local design-time connection?
Separate design-time and run-time connections are not required for all users. In fact, some of the Dreamweaver MX server models and platforms do not offer users a choice of using separate connections. However, many Dreamweaver MX users will have a choice and here are some reasons that you may want to consider using separate connections: