Home >
Online Product Documentation >
Table of Contents >
Options - Module Settings - DB-to-XML - Default Database Connection
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.
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
Cart
