• 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
  • Getting Started with XQuery in Stylus Studio
  • An XQuery Primer
  • Understanding FLWOR Expressions
  • Building an XQuery Using the Mapper
  • Working with the XQuery collection() Function
    • Using the collection() Function in Stylus Studio
    • How the collection() Function is Processed
    • Creating a Database Connection
      • Choosing a Database
      • Using the Server URL Field
      • Username and Password
      • How to Create a Database Connection
    • Creating a collection() Statement
    • Other Ways to Register a Database Configuration
  • Debugging XQuery Documents
  • Using DataDirect XQuery® Execution Plans
  • Creating an XQuery Scenario
  • Generating XQuery Documentation
  • Using XQuery to Invoke a Web Service
  • Generating Java Code for XQuery
• Chapter 11: Composing Web Service Calls
• Chapter 12: Building XML Pipelines
• Chapter 13: Publishing XML Data
• Chapter 14: Integrating with Third-Party File Systems
• Chapter 15: Extending Stylus Studio
• Chapter 16: The Stylus Studio Java API
• Chapter 17: Stylus Studio GUI Reference

Home >Online Product Documentation >Table of Contents >Creating a Database Connection

Creating a Database Connection

Before you can execute a collection() function in an XQuery document, you need to create a database connection. This is part of the process of making the database tables and views available to your XQuery code.

Specific properties vary from database to database, but to connect to a database you typically need to specify

This section describes these connection setting properties in greater detail and.

This section covers the following topics:

Choosing a Database

Stylus Studio allows you to connect to any of a number of natively supported relational databases, such as Oracle, Microsoft SQL Server, Sybase, Informix, and IBM DB2.

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.

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 data source.

How to Create a Database Connection

To create a database connection:

Stylus Studio displays the Connection Settings dialog box.

Figure 316. Connection Settings Dialog Box

The server connection appears in the File Explorer window.

Figure 317. New Database Server Connection