ADO and SQL Server

Catalog Location Property

The Catalog Location property indicates the position of the catalog name in a qualified table name in a text command.

Applies To
Connection Object

Syntax

object.Properties("Catalog Location")

Parts

object

Expression that evaluates to an object in the Applies To list.

Settings
Constant Description
DBPROPVAL_CL_START The catalog name is at the start of the fully qualified name.
DBPROPVAL_CL_END The catalog name is at the end of the fully qualified name.

Data Type

adInteger

Modifiable

Read-only

OLE DB Property

DBPROP_CATALOGLOCATION