Connecting to the Sample Data Source

Note: The ADO and ADO.NET clients are currently available only in OpenAccess SDK 8.1. However, they are compatible with the OpenAccess SDK 9.0 server.

You can test the connection using the DataDirect Configuration Manager, which is installed with the ADO client.

1. From the Start menu, select Progress DataDirect OpenAccess SDK 9.0 / Client for ADO / Configuration Manager.

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.

   Provide the following information:

   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” or “Accounting Data in Oracle”.

   Service Host: Type the TCP/IP host name of the OpenAccess SDK service to which you want the ADO Client to connect.

   Service Port: Type the port number that you assigned during the OpenAccess SDK Server installation (see Installing OpenAccess SDK Server). 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 20092.

   Service Data Source: Type Default.

5. Click Test Connect from the data source set up dialog box to establish a connection to the OpenAccess SDK service and data source. If successful, click OK and continue to Querying the Sample Data Source.

Refer to the OpenAccess SDK Administrator’s Guide for information about using the DataDirect Configuration Manager.