Studio allows adding an SQL server to the development environment and to configure server settings.
Studio supports the most popular SQL servers, with support for additional servers forthcoming. Currently, the following databases are supported: Oracle, MySQL, SQLite, Microsoft SQL Server, PostgreSQL, IBM Cloudscape and IBM DB2.
To add an SQL Server to Studio:
From Studio's File Manager, click the SQL tab.
Right-click to open the right-click menu.
Select the Add SQL Server option to open the Add SQL Server dialog.
Add SQL Server
Enter the SQL Server Settings in the fields.
The settings include:
|
|
Server Type - A list of Server Types supported in the current version of Studio. |
|
|
Server Name (Alias) - The name of the server that will appear on the SQL Tree (of the File Manager).
|
|
|
Host Name/IP - Address of the server. |
|
|
Port - When you choose a Server Type, the default port appears in this field automatically. |
|
|
Database Name - The name of the database that the server connects to. This field is names as SID in Oracles connections and as Database File in SQLite "flat-file" database connections |
|
|
User Name - Your approved User Name for the server. |
|
|
Password - The correct Password for the User Name. |
Enter the Connection Preferences using the checkboxes provided.
The preferences include:
|
|
Save Password - Saves the Password. |
|
|
Connect When Zend Studio Starts - Connects to the server whenever Zend Studio starts. |
|
|
Auto Reconnect - If the connection to the server is broken, Auto Reconnect attempts 3 times to reconnect. If it is unable to reconnect, it then registers a "disconnect" and Auto Reconnect will stop working. |
|
|
Test the Connection Every - Checks every n seconds to see if the server is responsive. Use the Seconds field to enter your preference. |
Click Test to attempt to connect to the SQL Server using the settings and connections currently entered in the Add SQL Server dialog box.
Click OK to accept the settings and preferences you
have entered.
Studio records your settings and automatically tests the connection
to the server.
Note:
If you made a mistake in either the User Name or Password, e.g., if the server does not recognize them as being valid, you will receive a pop-up that allows you to attempt to re-enter the information.
|
|
|
|
|
Related Links: |
|
|
|
