Options - General - Default Database Connection

You use this page of the Options dialog box to establish default settings to connect to a database. Once you define a default connection, you can select the Use Default Connection check box to connect to that database, rather than redefining the connection settings each time. (The Use Default Connection check box appears on the URL Builder tab of the Open dialog box.) 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 General > Default Database Connection.

Fields

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

Username required to log in to the database.

Password

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.

Buttons

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: