Options - Module Settings - DB-to-XML - Default Database Connection

You use this page of the Options dialog box to establish default settings required to connect to a database. Once you define a default connection, you can use it to create new DB-to-XML data sources, rather than redefining the connection settings each time. (The Use Default Connection check box appears on the Conection Settings page of the Scenario Properties dialog box for DB-to-XML data source scenarios.) Connection settings vary from database to database, but they typically include the server's URL, and the username and password required to log in to the database.

To display Default Connection page of the Options dialog box, select Tools > Options from the Stylus Studio menu bar, then select Module Setting > DB-to-XML > Default Database Connection.


Database Type

The type of database to which you want to connect. You can connect to one of the default relational databases supported by Stylus Studio (Oracle, MS SQL Server, Informix, and so on), or you can use DataDirect SequeLink to connect to any ODBC database you specify.

Server URL

The server URL (and, in some cases, other connection parameters). In addition to the server's location, connection parameters can include the server name, the port through which the connection is established, and other information, such as a server ID (SID).


Username required to log in to the database.


Password associated with the username.

Default Connection

Read-only field that shows you the URL that defines the default connection. Appears after you select a specific database to which to connect.



The button you use to test your connction to the database. Once connected, you can select the specific database you want to use for the default connection.

For More Information

Specifying Connection Settings

Overview of DB-to-XML Data Sources

Chapter 12Accessing Relational Data as XML

Free Stylus Studio XML Training:
W3C Member