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

In the Connections dialog box that is displayed, click Add Connection.

Fill out the dialog box that appears. Use the samples below as a guide.

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

Examples:


Simple Example




Secure Example




ODBC (Microsoft Access) Example




See also:

Managing Connections
MySQL on Linux Permissions
MS Access Permissions
ODBC Driver Limitations