Data Link Properties Dialog Box (Connection Tab)

This version of the Connection tab is designed specifically for you to enter connection information when you are performing one of these actions:

using the SAS IOM provider for OLE DB to access a SAS Workspace Server
using the SAS OLAP provider for OLE DB to access a SAS OLAP Server

Note: If you need to specify a SAS Metadata Server that has not been configured by using the SAS Integration Technologies configuration utility (ITConfig), then you must enter connection information on the Advanced tab in the Data Link Properties dialog box. To display that tab, click Advanced.

The customized Connection tab has these items:

Select or enter a Data Source

You have two choices, depending on where the server is located.

If you want a new, locally instantiated server connection, type _LOCAL_ in this field, and then click OK to make the connection.
If you want a remote server connection, use the Data Source URI format to specify the location of the SAS Workspace or SAS OLAP server that you want to access. For example, if you are connecting to a SAS Workspace Server configured as COM with host authentication, you might enter this code:
```
iom-com://workspace.example.com
```
If the SAS Workspace or SAS OLAP server is defined in an LDAP (Lightweight Directory Access Protocol) server or in a SAS Metadata Server, then the URI can use the logical name for the workspace or OLAP server. (The SAS Metadata Server must have been configured by using the ITConfig utility.) Here is a sample Data Source URI that references a logical name defined in a SAS Metadata Server:
```
iom-name://Logical Workspace Server
```
For more information about the Data Source URI, see Using the Data Source Property to Specify All Connection-Related Properties.

Note: If you do not complete the Data Source field, the SAS provider assumes that you want to establish a local connection.

Note: If your local connection does not succeed, then your system administrator must check your installation and COM permissions.

Enter information to log on to the server

For secure remote connections, enter your credentials in the User name and Password fields. (For the user name, type your user ID for logging on to the remote server.)

Test Connection

Click this button in order to test the connection.

For more information about completing the Connection tab, contact your system administrator.