• Chapter 1: Getting Started with Stylus Studio
• Chapter 2: Editing and Querying XML
• Chapter 3: Converting Non-XML Files to XML
• Chapter 4: Working with XSLT
• Chapter 5: Creating XSLT Using the XSLT Mapper
• Chapter 6: Debugging Stylesheets
• Chapter 7: Defining XML Schemas
• Chapter 8: Defining Document Type Definitions
• Chapter 9: Writing XPath Expressions
• Chapter 10: Working with XQuery in Stylus Studio
• Chapter 11: Composing Web Service Calls
• Chapter 12: Accessing Relational Data as XML
  • Overview of DB-to-XML Data Sources
  • Opening a New DB-to-XML Data Source Document
  • Specifying Connection Settings
    • Connection Settings Vary
    • Choosing a Database
    • Using the Server URL Field
    • Username and Password
  • Working with Scenarios
  • Composing SQL/XML in Stylus Studio
  • Working with Relational Data as XML
  • Using the URL Builder
• Chapter 13: Extending Stylus Studio
• Chapter 14: Stylus Studio GUI Reference

Home > Online Product Documentation > Table of Contents > Specifying Connection Settings

Specifying Connection Settings

You specify the information needed to connect to a server and log in to a relational database on the Connection Settings tab of the Scenario Properties dialog box. Stylus Studio displays this dialog box automatically when you open a new DB-to-XML data source. (You can also display the Scenario Properties dialog box manually. See Opening the Scenario Properties Dialog Box.)

The connection settings you specify on the Connection Settings tab of the Scenario Properties dialog box are saved with the DB-to-XML data source.

This section covers the following topics:

Connection Settings Vary

Connection settings vary from database to database, but they typically include the following:

Choosing a Database

Stylus Studio allows you to connect to

If you want to connect to one of the relational databases supported by Stylus Studio, simply select the database from the Database Type drop-down list. If you want to use a database that is not natively supported, select DataDirect SequeLink.

Using SequeLink

You can use DataDirect SequeLink to connect to any database that complies with the Microsoft Open Database Connectivity (ODBC) specification. This process involves:

SequeLink product software and documentation are in the \SequeLink directory where you installed Stylus Studio ( c:\Program Files\Stylus Studio\SequeLink, for example). See the Stylus Studio Release Notes for information on installing SequeLink Server.

Using the Server URL Field

You use the Server URL field to identify the server hosting the database to which you want to connect, the port to use, and any other required or optional parameters. For example, the string used to connect to a Microsoft SQL Server database might look like this:

The specific syntax of the string you enter in the Server URL field varies based on database type. Consult your database documentation for information regarding connectivity syntax and optional parameters.

Username and Password

You use the Username and Password fields to specify the database user you want to associate with this DB-to-XML data source.