After deploying the database, you must modify any database connection to it so your Web application can still find and interact with it.

If you used a data source name (DSN) to connect to the database during development and you want to use a DSN to the deployed database, you must create an identically named DSN on the host server. For example, if your application used a DSN called "operations" when you worked on it in UltraDev, then you must define a new DSN called "operations" on the host server. The identically named DSN must point to the deployed database—either on the host server itself or on another server, in the case of a large, server-based database.

For instructions on creating a DSN on a Windows server, see "Setting Up a DSN" in UltraDev help (Help > Using UltraDev), or on page 249 of Using Dreamweaver UltraDev 4.

After creating a DSN on the host server, you must tell UltraDev to use it from now on when you need to work on the deployed dynamic pages.

You can also ignore the following procedure if you're a Macintosh user. In your case, all DSN connections use a DSN on the application server.

To tell UltraDev to use the DSN on the host server when working on the dynamic pages:

1	Open a page in UltraDev and choose Modify > Connections.
	The Connections dialog box appears.
2	Select the connection from the list and click Edit.
	The Data Source Name (DSN) dialog box appears.
3	Select Using DSN on the Application Server.
	This tells UltraDev to connect to the database using the DSN on the application server and not the one on the local machine. The DSN on the application server should point to the deployed database.
4	Click Test.
	UltraDev attempts to connect to the deployed database. If the connection fails, make sure the database is deployed and the appropriate DSN is defined on the server.
5	Click OK, then click Done.