Userid connection parameter [UID]

Function

Specifies the user ID with which you log on to the database.

Usage

Anywhere. (DSN and FILEDSN connection parameters do not support verbose form of keyword.)

Default

None

Description

You must always supply a user ID when connecting to a database. The user ID is not case sensitive, and is unaffected by the setting of the Case Respect database property.

Examples

The following connection string fragment supplies the user ID DBA and password SQL:

uid=DBA;pwd=SQL