Creating an ADO Client Data Source

Start the DataDirect Configuration Manager. To start the Configuration Manager, select Start / Programs / Progress DataDirect OpenAccess Client for ADO SDK 8.1 / Configuration Manager. The Configuration Manager dialog box is displayed.

Select Add. The Configuration Manager dialog box provides a text entry field to enter a data source name.

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.

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.

On the General tab, provide the following information; then, click Apply.

Optionally, click the Failover tab to enable tracing options. Specify values on the Failover tab, then, click Apply.

Note: Settings on this tab apply to all data sources for the ADO Client. You cannot set the trace options programatically.

Optionally, click the Security tab to specify security data source settings.

For more information about encrypting data, refer to the OpenAccess SDK Administrator’s Guide.

At any point during the configuration process, you can click Test Connect to attempt to connect to the data source using the connection attributes specified in the provider Setup dialog box. A logon dialog box appears; see Connecting to an ADO Client 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.