• 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
    • Creating a collection() Statement
    • Other Ways to Register a Database Configuration
  • Debugging XQuery Documents
  • 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: Accessing Relational Data as XML
• Chapter 13: Building XML Pipelines
• Chapter 14: Publishing XML Data
• Chapter 15: Integrating with Third-Party File Systems
• Chapter 16: Extending Stylus Studio
• Chapter 17: The Stylus Studio Java API
• Chapter 18: 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 the XQuery code.

To create a database connection:

Stylus Studio displays the Connection Settings dialog box.

Figure 331. Connection Settings Dialog Box

The server connection appears in the File Explorer window.

Figure 332. New Database Server Connection