Home > Tutorials > Connector Tutorial > Connecting to a Data Source > Editing Data Connection Properties

Editing Data Connection Properties

Overview

Once you have created a data connection, you are able to view the data connection's details in the Property window. (The property window displays the properties of any selected object).

You are also able to edit your connection properties in the property window, by doing any of the following:

• Change the connection properties
• Rename a connection
• Delete a connection
• Move a connection

Complete the following editing exercises:

Exercise 1: Renaming a Connection

To make it easy for our report writers to recognize the data connection, rename the connection to: Sage Accpac Intelligence Tutorial

Step by Step Solution:

1. Select the Data connection.
2. Edit the connection name in the Connection Name property field and click Apply.

Exercise 2: Move a Connection

• Move the Connection: Sage Accpac Intelligence Tutorial from the ODBC driver for Access connection type to the ODBC Driver for dBase connection type.
• Check the connection. An error message is displayed as the connection is located in the wrong ODBC driver.
• Move it back to its original ODBC driver location.

Step-by-Step Solution:

1. Select the Data connection: Sage Accpac Intelligence Tutorial.
2. Right-click and select Move to.
3. Select the connection type: ODBC Driver for Dbase from the displayed list and click OK.
4. Click OK. The data connection is moved to the ODBC Driver for Dbase connection type.
5. Double-click on the ODBC Driver for Dbase to view the moved data connection.
6. Right-click on the connection and select Check/Test. An error message is displayed.
7. Select the Data connection: Sage Accpac Intelligence Tutorial.
8. Right-click and select move to.
9. Select the connection type: ODBC Driver for Access from the displayed list and click OK.

Next-->