When you access a Sybase Adaptive Server Enterprise database in DataWindow Designer through Open Client, DS_Provider is one of several parameters that you can set to enable network-based directory services in your application. (For other directory services parameters, see the See Also section.)
When you use Open Client directory services, you must specify your directory service provider names in the Open Client/Open Server Configuration utility so that the required drivers can be loaded for each provider. The default directory service provider is the one currently specified as active in the Configuration utility.
DS_Provider lets you specify a directory service provider name listed in the Open Client/Open Server Configuration utility other than the default (active) provider. The default value for DS_Provider is the provider name currently specified as active in the Configuration utility.
You must specify a value for DS_Provider before connecting to the database in DataWindow Designer.
Using third-party directory service providers
For information about the third-party directory
service providers and operating system platforms that Sybase has
tested with Open Client directory services, see the Open Client
documentation.
SYC Sybase Adaptive Server Enterprise
DS_Provider = 'provider_name'
Parameter |
Description |
|---|---|
provider_name |
The directory service provider name you want to use for directory services. The provider name is case sensitive. You must specify it exactly as it appears in the Open Client/Open Server Configuration utility. |
The default value for DS_Provider is the provider name currently specified as active in the Open Client/Open Server Configuration utility.
When to use Set DS_Provider to use a directory service provider specified in the Open Client/Open Server Configuration utility other than the default (active) provider. For instructions on using the Open Client/Open Server Configuration utility, see your Sybase Open Client/Server configuration guide.
Set Release parameter For this parameter to take effect, you must also set the Release parameter to 11or higher to specify that your application should use the appropriate version of Sybase Open Client Client-Library (CT-Lib) behavior. See the description of the Release parameter for more information.
Requirements for use To use DS_Provider or any other parameter supporting Open Client directory services, you must meet certain requirements for using directory services in your DataWindow Designer application. For details, see “Requirements for using Open Client directory services” in Connecting to Your Database.
Corresponding CT-Lib connection property Specifying a value for DS_Provider sets the corresponding Sybase CT-Lib connection property named CS_DS_PROVIDER.
To specify NTREGISTRY as the directory service provider name:
Database profile Type the following in the Provider box on the Directory Services tab in the Database Profile Setup dialog box:
NTREGISTRY
Application Type the following in code:
SQLCA.DbParameter = "DS_Provider='NTREGISTRY'"
