You are here: User Guide > Tasks > Connecting to Databases > Creating a Database Connection Profile

Creating a Database Connection Profile

This procedure describes how to create a connection profile to your database, allowing you to easily connect to it through the Database Development perspective.

The drivers for most of the database connection types are automatically included and configured in Zend Studio.

However, some drivers require you to manually add and configure the driver archive files.

The following driver types come bundled and preconfigured in Zend Studio:

 

 

Instructions on how to complete a procedure

To create a connection profile:

  1. In the PHP Perspective toolbar, click the Create New SQL Connection icon
    -Or- in the Database Development perspective (Window | Open Perspective | Other | Database Development), click the Create New SQL Connection icon  in the Data Source Explorer view or on the main Toolbar
    -Or- right-click the Database Connections folder in the Data Source Explorer view and select New.

  2. The New Connection Profile wizard opens.

New Connection Profile Dialog

  1. Select the required connection profile type from the list.

Enter a name for the connection and a description (if required).

Note:

The drivers for most of the database connection types are automatically included and configured in Zend Studio. However, some driver types require you to manually add and configure the driver archive files.

The following driver types come bundled and preconfigured in Zend Studio:

  • DB2

  • SB2 i-series

  • Derby

  • MySQL

  • Oracle

  • Postre SQL

  • SQL Server

  1. Click Next.
    Select a driver from the drop-down list.
    If the required database driver has not been configured, click the New Driver Definition button to the right of the drop-down list and perform the following steps:

  1. In the Name/Type tab, select the required driver type and version.

  2. Select the Jar List tab.

  3. Click Add JAR/Zip.

  4. Browse to the JAR/Zip file containing the required driver files and click Open.

  5. Click OK.
    The new driver is added to the driver definition list.

  1. The properties for the selected driver are displayed.
    These will vary depending on the database type.

  2. Click the Test Connection button to ensure all the details have been entered correctly.

  3. Click Next to see a summary of your Connection Profile's details.

  4. Click Finish.

Your new connection profile will be added to your databases list in the Data Source Explorer view.

You can now use this Connection Profile to connect to your database.

See the Connecting to a Database topic for more on how to connect to your database.

 

Note:

To change the properties of your connection profile, right-click it in the Data Source Explorer view and select 'Properties'.

For more information on the Data Tools Platform, please see the Data Tools Platform User Documentation .

Note:

Additional user guides can be accessed from inside Zend Studio by going to Help | Help Contents, or from the Eclipse Online Documentation site (http://help.eclipse.org/helios/index.jsp).

 

 

Related Links:

Using the Data Tools Platform

Connecting to a Database

Viewing and Editing Database Table Content

Creating and Executing an SQL Query

 

 

©1999-2012 Zend Technologies LTD. All rights reserved.