Importing Database Connection Profiles

Import database connection profiles directly from a sql.ini file or LDAP server.

Prerequisites

If you are importing from a sql.ini file you must have access to the file. If you are importing from an LDAP server, you can import from a running OpenLDAP server. See the Adaptive Server Enterprise collection under Sybase WorkSpace Server Administration.

From the Enterprise Explorer toolbar, select the Import Connection Profiles icon.
The Import Connection Profiles wizard appears.

Choose one of the following options, supply the required information, and click Next.

Option	Description
Import from a SQL.INI File	Specify the full path and file name, or browse to the sql.ini file from which the connection profiles are imported.
Import from a LDAP Server	Supply the following: Host – the name of the host machine on which the LDAP server is running. Port – the port number used to access the LDAP server. Scope – the scope of the search, which can be one of these values: one – retrieves information about entries one level below the base DN specified in the URL. The base entry is included in this scope. object – if specified, retrieves zero or one entry from the base Search DN, or if not specified, retrieves information about the base DN. subtree – retrieves information about entries at all levels below the base DN specified in the URL. The base entry is included in this scope. Base DN – distinguished name (DN) of an entry in the directory. The base DN identifies the entry that is the starting point of the search if the base search DN is not provided. Base Search DN – identifies the entry that is the starting point of the search. User DN – if supplied, operations use the current user's DN and password if the user is known and anonymous if not. Password – the password of the user DN. Append Base – appends the Base DN to the User's DN. Anonymous – select this option to connect to the LDAP server if you do not know the user DN. Select Test Connection to verify access to the LDAP server.

Option

Description

Import from a SQL.INI File

Specify the full path and file name, or browse to the sql.ini file from which the connection profiles are imported.

Import from a LDAP Server

Supply the following:

Host – the name of the host machine on which the LDAP server is running.
Port – the port number used to access the LDAP server.
Scope – the scope of the search, which can be one of these values:
- one – retrieves information about entries one level below the base DN specified in the URL. The base entry is included in this scope.
- object – if specified, retrieves zero or one entry from the base Search DN, or if not specified, retrieves information about the base DN.
- subtree – retrieves information about entries at all levels below the base DN specified in the URL. The base entry is included in this scope.
Base DN – distinguished name (DN) of an entry in the directory. The base DN identifies the entry that is the starting point of the search if the base search DN is not provided.
Base Search DN – identifies the entry that is the starting point of the search.
User DN – if supplied, operations use the current user's DN and password if the user is known and anonymous if not.
Password – the password of the user DN.
Append Base – appends the Base DN to the User's DN.
Anonymous – select this option to connect to the LDAP server if you do not know the user DN.

Select Test Connection to verify access to the LDAP server.

The Set Default Username and Password wizard page appears.

(Optional) Set the default user name and password used to access the imported connection profiles and click Next. Although this step is optional, you must define a user name in this step or the next.
- User Name – the connection profile user name.
- Password – the user's password.
- Connection Profile Type – select the connection profile type.
- Use These Values as Default Values for all Connection Profiles – enable the connection profile settings.
The Select the Entries to be Created wizard appears.

The connection profile of all retrieved entries displays. Select the entries to import and click Next.

Note: Only supported entries display. For example, only NLWNSCK and TCP entries of the selected sql.ini file are allowed.

Table 1. Select the entries to be created
Field	Description
Entry Filtering	Define which entries to display using any of these options and clicking Filter: Display all entries – select this option to display all retrieved entries. Display by connection profile type – select this option and choose a profile type to display retrieved entries of that profile type. Display by host name pattern – select this option and enter a host name (including wildcard characters) to display entries of a target host.
Set Values for Multiple Entries	These options allow you to batch set properties of the imported connection profiles. You must select at least two entries to enable these options. Set connection profile type – set the profile type for the selected entries. Set value for – select an option, enter a value in the supplied field, and click Apply to assign the value to all selected connection profiles.
Select	Use the Select button (or Select All or Unselect All) to select or unselect available connection profiles. You can set values for multiple entries. Highlight individual entries to modify properties for that connection profile. Note: You must supply a value in the Profile User Name field for every connection profile you want to import.

Review the Summary page. Click Back to make changes or Finish to create the connection profiles.

Profiles appear in the Enterprise Explorer under Databases.

Next