Connection Manager Dialog Box

The Connection Manager allows you to create new and maintain existing server connections. It also allows you to assign connections to connection groups.

Each server connection has a unique name, optional description, and set of required database connection parameters, as the following list shows.

The General tab allows you to enter a new connection name and edit selected connection names, modify the connection description, and assign a connection to one of the existing connection groups.
Use the Group list box to assign a connection to a specific group of connections. If the required group of connections does not exist yet, press Edit on the right side of the Group list box to open the Connection Group Manager dialog box. Using the Connection Group Manager dialog box, you can create new and edit existing connection groups.
Use Tab Color dropdown to set optional color-coding of document tabs for the selected server connection. Color-coding of document tabs in the application frame window allows to visually differentiating documents, such as SQL Editors, when they are connected to different servers. Click here for more information on document tabs color-coding.
The Database tab allows you to enter DBMS-specific JDBC connection parameters. IBM Informix databases require the following fields:
- Server Name
- Host and Port Number
You cannot save a connection without providing the above fields.The User, Password, and Database fields are optional and allow you to enter default parameters, which you can override in the Connect dialog box during the connection time. You can successfully save the connection without providing these parameters. You must enter these parameters if you want to use the Test Connection or the Connect options of the Connection Manager.
Host and Port Number
The Host Name and Port number are entered using colon between these two values.
For example, MYDEVSERVER:1526
For the host you can specify either the name of the host computer or IP address.
The Port Number can be received from your Database Administrator or by looking up SQLHOSTS file at the server-side for UNIX servers or SQLHOSTS Windows Registry Key value for Windows NT servers. You can find SQLHOSTS registry key under HKEY_LOCAL_MACHINE\SOFTWARE\Informix folder. Also if you use any other Windows application connecting to Informix from your workstation, you can use Informix SetNet32.exe utility from your Informix Client installation to look up the port number for your server. The Server Studio JE requires port number - not a service name. As a result, if the SetNet32 utility displays the service name instead of the port number, you have to find a port number for this service using WINNT\system32\drivers\etc\services file.
Press Advanced button to open the Environment dialog box, which allows you to enter additional JDBC driver environmental variables, such as DB Locale, Client Locale, Date Format, and so forth.
Press Connect to save a connection, immediately connect it to a server and close the Connection Manager window.
Press Test Connection if you want to test the entered JDBC driver and user login parameters but do not want to save a connection yet.
Press Close to close the Connection Manager dialog box. If you made any modifications to a selected profile and have not saved it, the Close Confirmation message is displayed.
Press New to create a new blank connection.
Press Save if you want to save a selected connection without connecting to a server and closing the Connection Manager window. It allows you to create multiple server connections from within a single Connection Manager session.
Press Save As to make a copy of the selected connection.
Press Delete to delete a selected connection.

In addition, if the Server Administrator plug-in module is installed, the Host Access tab allows you to configure remote access to the server using Telnet or SSH protocols. With this access you can execute server-side commands and scripts, such as ONSTAT or ONMODE, and use server administration functions, such as Start/Stop server or terminate user session. See Configuring Remote Host Access topic under the Server Administrator chapter for more information on setting up remote host access.