ProviderString

Description

When connecting to a Microsoft SQL Server database, identifies the specific database on the server to which you want to connect.

When to specify ProviderString You must specify the ProviderString parameter before connecting to the database.

Applies to

ADO.NET
OLE DB

Syntax

ProviderString = 'value'

Default

None

Usage

Since Microsoft SQL Server supports multiple instances of a database on a single server, you must identify the specific database to which you want to connect by entering the database name.

For more information, see the documentation for Microsoft SQL Server.

Examples

Example 1

To identify a specific Microsoft SQL Server database:

Database profile Enter the following in the Extended Properties box on the Connection tab in the Database Profile Setup dialog box for OLE DB, or in the Driver-Specific Parameters box for ADO.NET:
```
Database = demodb1
```

Application Type the following in code:

SQLCA.DBParm="ProviderString='database=demodb1'"