Before you have a connection, you can use Data Explorer to assemble connection strings.

1. Choose ViewData Explorer or click the Data Explorer tab in the Project Manager.
2. Expand a provider node under dbExpress to expose the list of available database providers.
3. Expand the second–level provider node to view the list of potential connections.

1. In the Data Explorer list of providers, right-click a second–level provider.
2. In the context menu, click Modify Connection. The Modify Connection dialog is displayed.
3. In the Modify Connection dialog, click Advanced. The Advanced Properties dialog is displayed, containing a scrollable list of connection properties. The left column contains connection string keys; the right column contains their values.

1. In the Advanced Properties dialog, enter values in the right-hand column for the connection properties named in the left column.
2. The text field at the bottom of the Advanced Properties dialog contains the resulting connection string text. Drag the cursor over the connection string text to select the connection string text. Copy the text. You can then paste this connection string wherever you want.