Connection Settings

You use the Connection Settings dialog box to specify connectivity settings for a relational database server.

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).

See Supported Databases for more information about this field.

Driver Classpath

For certain relational databases (MySQL Community Edition and PostgreSQL, for example), you need to specify the classpath of the driver that supports the relational database.

Server URL

The server's network location and other inforamation including the server name, the port through which the connection is established, and other information, such as a server ID (SID). Stylus Studio displays default information for this field when you select a database type.

See Using the Server URL Field for more information about this field.

Username

The username required to log in to the database.

Password

The password associated with the username.

For More Information

Creating a Database Connection

Working with the XQuery collection() Function

 
Free Stylus Studio XML Training: