Creating a New Connection in Server Explorer

You can select the database to which you want to connect from a list of available databases when you create a connection or want to change the database in an existing connection.

The following example demonstrates connecting to an Oracle database. The method is similar for all of DataDirect Connect for ADO.NET data providers.

To select the database in a new connection:

1. In Server Explorer, right-click the Data Connections node, and select Add Connection.... The Change Data Source dialog box appears.

2. In the Data source list box, select Progress DataDirect. Then, in the Data provider drop-down list, select Progress DataDirect Connect for ADO.NET Oracle Data Provider. Then, click OK.

   

3. The Add Connection dialog box appears. Default values may appear in some fields. Add the host, port, and other connection information for your environment, and click OK.

   

Note: After creating the connection, you can run the Performance Tuning Wizard to determine optimal settings for performance. See Using the Performance Tuning Wizard for more information.