ADO and SQL Server

Data Source Property

The Data Source property specifies the name of the database to which to connect.

Applies To
Connection Object

Syntax

object.Properties("Data Source") [= value]

Parts

object

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

value

String that specifies the name of the database.

Data Type

adBSTR

Modifiable

Read/write

OLE DB Property

DBPROP_INIT_DATASOURCE

Remarks

An ADO application can also use the OLE DB Server keyword, which is equivalent to the Data Source property.