1. Start the Configuration Manager. To start the Configuration Manager, select Start / Programs, and select Progress DataDirect OpenAccess Client for ADO SDK 8.1 / Configuration Manager.
The Configuration Manager dialog box is displayed.
2. Click Add. The Configuration Manager provides a text entry field to enter a data source name.
3. Type a name for the data source. All data sources located in the same directory must have unique names. If the name has already been used for another data source, you are prompted to enter a different name.
4. Click OK.
The General tab of the DataDirect SSIS OLE DB Provider for OpenAccess SDK Setup dialog box appears by default.
Note: The General tab displays only fields that are required for creating a data source. The fields on all other tabs are optional, unless noted otherwise.
5. On the General tab, provide the following information; then, click Apply.
Data Source Name: This is a read-only field that contains the data source name you specified in Step 3.
Description: Optionally, type a description of the data source. For example, My Accounting Database.
Service Host: Type the TCP/IP host name of the OpenAccess SDK service to which you want the ADO Client to connect. This field is available only if the Use LDAP check box is not selected.
Service Port: Type the TCP/IP port the OpenAccess SDK service is listening on for incoming connection requests. The port you specify must be the same as the one that was specified for the OpenAccess SDK service when the OpenAccess SDK Server was installed; the default is 19986. This field is available only if the Use LDAP check box is not selected.
Service Data Source: Type the name of a server data source configured for the OpenAccess SDK service to use for the connection, or select one from the drop-down list. This field is optional. If a server data source is not specified, the default server data source for that OpenAccess SDK service will be used for the connection. This field is available only if the Use LDAP check box is not selected.
Use LDAP: To configure the ADO Client to retrieve connection information from an LDAP directory, select the Use LDAP check box. The fields change to accommodate the information that is required to query an LDAP server for connection information. Provide the following information:
LDAP Server Host: Type the TCP/IP host name of the LDAP server.
LDAP Server Port: Type the TCP/IP port on which the LDAP server is listening for incoming connection requests. If unspecified, the ADO Client will use the default LDAP port 389.
Distinguished Name (DN): Type an identifier that uniquely identifies the LDAP entry where connection information is stored.
Custom Properties: Type a custom property and value specific to your data source. The ADO Client passes the value to the IP layer.
6. Optionally, click the Failover tab to enable failover options. Specify values on the Failover tab, then, click Apply.
Note: Settings on this tab apply to all data sources for the ADO data provider. You cannot set the trace options programatically.
Load Balancing: elect whether the data provider uses client load balancing in its attempts to connect to a list of OpenAccess SDK servers (primary and alternate). The list of alternate servers is specified by the Alternate Servers attribute.
Alternate Servers: Type a list of alternate OpenAccess SDK servers that the data provider will try to connect to if the primary OpenAccess SDK server is unavailable. The value of this property is a string that has the format:
The server name is required for each alternate server entry. Connection options (property=value) are optional for each alternate server entry.
Connection Retry Count: Type the number the data provider retries connection attempts to the primary OpenAccess SDK server, and if specified, alternate OpenAccess SDK servers until a successful connection is established. Valid values are 0 and any positive integer.
If set to 0, the data provider does not try to reconnect after the initial unsuccessful attempt.
Connection Retry Delay: Type the seconds the data provider waits after the initial unsuccessful connection attempt before retrying a connection to the primary OpenAccess SDK server and, if specified, to the alternate OpenAccess SDK servers. Valid values are integers from 0 to 65535. The default value is 3 (seconds). If set to 0, there is no delay between retries.
Note: This option has no effect unless the Connection Retry Count connection option is set to an integer value greater than 0..
Force SQL_DRIVER_NOPROMPT: Select this check box when connection failover or load balancing is enabled. This check box must be also selected if the application cannot change the DriverCompletion argument to SQL_DRIVER_NOPROMPT.
If this check box is not selected (the default), the behavior of the application is not changed.
7. Optionally, click the Security tab to specify security data source settings.
Provide any of the following information; then, click Apply.
Encrypted (SSL): If the remote OpenAccess SDK service is configured for Secure Sockets Layer (SSL) encryption, select this check box. If connecting to a service enabled for SSL, you must select this check box.
When the check box is cleared (the default), communication between the OpenAccess SDK Client and OpenAccess SDK Server is not encrypted.
Configuration of encryption is performed on the OpenAccess SDK Server. See Using SSL Encryption for a discussion of encrypting data.
Truststore: If you are using SSL, type the path that specifies the location of the truststore file. The truststore file contains a list of the valid Certificate Authorities (CAs) that are trusted by the client machine for SSL server authentication.
Truststore Password: If you are using SSL, type the password required to access the truststore.
Host Name In Certificate: If you are using SSL, type the host name established by the SSL administrator for the data provider to validate the host name contained in the certificate. If no value is specified for Host Name In Certificate, the data provider does not check the host name in the server certificate. The value of Host Name In Certificate is ignored if the Encrypted (SSL) check box is not selected.
8. At any point during the configuration process, you can click Test Connect to attempt to connect to the data source using the connection properties specified in the provider Setup dialog box. A logon dialog box appears; see Connecting to an ADO Data Source for details.
Note that the information you enter in the logon dialog box during a test connect is not saved.
If the data provider can connect, it releases the connection and displays a Connection Established message. Click OK.
If the data provider cannot connect because of an improper environment or incorrect connection value, it displays an appropriate error message. Click OK.
Note: If you are configuring alternate servers for use with the connection failover feature, be aware that the Test Connect button tests only the primary server, not the alternate servers.
9. Click OK or Cancel. If you click OK, the values you have specified become the defaults when you connect to the data source. You can change these defaults by using this procedure to reconfigure your data source. You can override these defaults by connecting to the data source using a connection string with alternate values.
Note: All data sources are saved to the current directory displayed in the Configuration Manager. See Changing Data Source Directories for instructions on changing the current directory.
If the data provider can connect, it releases the connection and displays a Connection Established message. Click OK.