Advanced Tab, Data Link Properties Dialog Box

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

Note   For more information about advanced initialization properties, see the documentation provided with your OLE DB provider.

Tab Options

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 RPC. 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 RPC. 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.
  
  
• IdentifyùThe server can obtain the client's identity. The server can impersonate the client for 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.
  
  
• 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.

Protection Level

The level of protection of data 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 RPC. 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 RPC. Select from the following levels:

• NoneùPerforms no authentication of data sent to the server.
  
  
• ConnectùAuthenticates only when the client establishes the connection with the server.
  
  
• CallùAuthenticates the source of the data at the beginning of each request from the client 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.

Prompt

Specifies whether to prompt the user during initialization. Select from the following options:

• PromptùAlways prompt the user for initialization information.
  
  
• CompleteùPrompt the user only if more information is needed.
  
  
• Complete RequiredùPrompt the user only if more information is needed. Do not allow the user to enter optional information.
  
  
• No PromptùDo not prompt the user.

Locale

Specifies the locale ID (LCID)of preference for the consumer. Consumers specify the LCID at initialization. This provides a method for the server to determine the consumer's LCID of choice in cases where it can use this information. This property does not guarantee that all text returned to the consumer will be translated according to the LCID.

Access Permissions

Specifies the access permissions. Select one or more of the following permissions:

• ReadùRead-only.
  
  
• WriteùWrite-only.
  
  
• ReadWriteùRead and write.
  
  
• 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
  
  
• Share Deny NoneùNeither read nor write access can be denied to others.

Asynchronous Processing

Specifies the asynchronous processing performed on the rowset.

See Also

Working with Data Link Properties