Location

Description

Specifies the location of the data source to which you want your OLE DB data provider to connect. Typically the location is the database server name.

When to specify Location

You must specify the Location parameter before connecting to the database.

Applies to

OLE DB

Syntax

Location='location_name'

Default value

None

Usage

Implementation of the Location parameter varies depending on the OLE DB data provider you are using. For specific information, see the data provider documentation provided by the OLE DB vendor.