ADO and SQL Server

User ID Property

The User ID property specifies the user ID to use when connecting to the data source.

Applies To
Connection Object

Syntax

object.Properties("User ID") [= value]

Parts

object

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

value

String containing the user ID.

Data Type

adBSTR

Modifiable

Read/write

OLE DB Property

DBPROP_AUTH_USERID

Remarks

An ADO application can also use the OLE DB UID keyword, which is equivalent to the User ID property.

Note  The recommended method for connecting to an instance of Microsoft® SQL Server™ 2000 is Windows Authentication mode.