Advanced Tab

Use the Advanced tab to view and set additional initialization properties for your data.

The Advanced tab of the Data Link Properties dialog box is provider-specific and displays only the initialization properties required by the selected OLE DB provider. For more information about advanced initialization properties, see the documentation provided with each specific OLE DB provider.

The following table describes most initialization options.

Option

Description

Impersonation level

The level of impersonation that the server is allowed to use when impersonating the client. This property applies only to network connections other than Remote Procedure Call (RPC) connections; these impersonation levels are similar to those provided by RPCs. The values of this property correspond directly to the levels of impersonation that can be specified for authenticated RPC connections, but can be applied to connections other than authenticated RPCs. Select from the following levels:

  • Anonymous—The client is anonymous to the server. The server process cannot obtain identification information about the client and cannot impersonate the client.

  • Delegate—The process can impersonate the client's security context while acting on behalf of the client. The server process can also make outgoing calls to other servers while acting on behalf of the client.

  • Identify—The server can obtain the client's identity. The server can impersonate the client for Access Control List (ACL) checking but cannot access system objects as the client.

  • Impersonate—The server process can impersonate the client's security context while acting on behalf of the client. This information is obtained when the connection is established, not on every call.

Protection level

The level of data protection sent between client and server. This property applies only to network connections other than RPC connections; these protection levels are similar to those provided by RPCs. The values of this property correspond directly to the levels of protection that can be specified for authenticated RPC connections, but can be applied to connections other than authenticated RPCs. Select from the following levels:

  • Call—Authenticates the source of the data at the beginning of each request from the client to the server.

  • Connect—Authenticates only when the client establishes the connection with the server.

  • None—Performs no authentication of data sent to the server.

  • Pkt—Authenticates that all data received is from the client.

  • Pkt Integrity—Authenticates that all data received is from the client and that it has not been changed in transit.

  • Pkt Privacy—Authenticates that all data received is from the client, that it has not been changed in transit, and protects the privacy of the data by encrypting it.

Connect timeout

Specifies the amount of time (in seconds) that the OLE DB provider waits for initialization to complete. If initialization times out, an error is returned and the connection is not created.

Access permissions

Select one or more of the following permissions:

  • Read—Read only.

  • ReadWrite—Read and write.

  • Share Deny None—Neither read nor write access can be denied to others.

  • Share Deny Read—Prevents others from opening in read mode.

  • Share Deny Write—Prevents others from opening in write mode.

  • Share Exclusive—Prevents others from opening in read/write mode.

  • Write—Write only.

Remarks

Note

For more Data Link initialization information, see the Data Link API Overview on MSDN.