Creating a Database Connection from the File Explorer

You can also create a database connection from the File Explorer window.

To create a database connection:

1. Display the File Explorer window if it is not already open ( View > File Explorer).

2. In the File Explorer window, right-click the RelationalDB icon and select New Server from the short-cut menu.

Stylus Studio displays the Connection Settings dialog box.

Figure 374. Connection Settings Dialog Box

3. Specify the information needed to create the database connection and click OK. (See Specifying Connection Settings if you need help with this step.)

The server connection appears in the File Explorer window.

Figure 375. New Database Server Connection

4. Expand the server connection to expose the relational objects you want to include in your DB-to-XML data source.

< Previous | Next >

Download a 15 Day Free Trial Now >

See What's New for 2012 in Stylus Studio X14 >

Purchase Stylus Studio X14 Now >

SQL Server Tools

Integrated SQL Server Tools in Stylus Studio enable you to access relational data stored in SQL Server 2000 or SQL Server 2005 as XML using XQuery, SQL/XML or ADO - learn how to export relational data as XML today!

Accessing Relational Databases as XML with Stylus Studio's File Explorer

This demonstration is the first part of our series on working with relational and XML data, covering how to use Stylus Studio's File Explorer to connect to and query relational database tables as XML.

XML Generator

Create sample XML instance documents from any XML Schema using the XML Generator. The generated XML document is always valid, well-formed XML!

WYSIWYG XSLT Designer

Stylus Studio's powerful and easy-to-use WYSIWYG ("What you see is what you get") XSLT Designer lets you create XSLT stylesheets without writing any code! Go from a blank slate to solid, robust XSLT in minutes, using simple drag-and-drop operations.