Creating a Connection


Connections are created by specifying the paramenters needed to connect to the database server. These parameters include:

DBMS
Server Name
Database Name
Port (optional), specify 0 to use the default port
User Name and Password (both optional)

Create a Connection

On the Tools menu, click Add Connection.

Fill out the dialog box that appears. See the sample below as a guide.

Click Test to ensure the connection can connect, then click Ok.


Connection Example



Optional Parameters

The Optional Parameters field can be used to send additional parameters to the server when initiating a connection. Here are some examples:

MySQL Example - To specify UTF8 or Unicode:

useUnicode=true&characterEncoding=UTF8
characterEncoding=UTF8

SQL Server Example - To specify a named instance:

instance=anInstance



See also:

Managing Connections