Initialization and Authorization Properties

SQLOLEDB interprets OLE DB initialization and authorization properties as follows.

Property ID Description
DBPROP_AUTH_CACHE_
AUTHINFO
Ignored if set. SQLOLEDB does not cache authentication information.
DBPROP_AUTH_ENCRYPT_
PASSWORD
Ignored if set. SQLOLEDB uses standard SQL Server security mechanisms to ensure password privacy.
DBPROP_AUTH_
INTEGRATED
Ignored if set. SQLOLEDB uses SQL Server Authentication Mode by default. Windows NT Authentication Mode can be selected using the SQLOLEDB-specific SSPROP_AUTH_
TRUSTEDCONNECTION property.
DBPROP_AUTH_MASK_
PASSWORD
Ignored if set. SQLOLEDB uses standard SQL Server security mechanisms to ensure password privacy.
DBPROP_AUTH_PASSWORD The password assigned to a SQL Server login. This property is used when SQL Sever Authentication Mode is selected for authorizing access to a SQL Server database.
DBPROP_AUTH_PERSIST_
ENCRYPTED
Ignored if set.
DBPROP_AUTH_PERSIST_
SENSITIVE_AUTHINFO
SQLOLEDB persists authentication values, including an image of a password, if requested to do so. No encryption is provided.
DBPROP_AUTH_USERID A SQL Server login. This property is used when SQL Sever Authentication Mode is selected for authorizing access to a SQL Server database.
DBPROP_INIT_ASYNCH SQLOLEDB does not support this property. An error is returned on an attempt to set its value.
DBPROP_INIT_
DATASOURCE
An existing SQL Server database. On session creation, the database is selected as the execution context for the connection.
DBPROP_INIT_HWND A window handle from the calling application. A valid window handle is required for the initialization dialog box displayed when prompting for initialization properties is allowed.
DBPROP_INIT_
IMPERSONATION_LEVEL
Not supported by SQLOLEDB. An attempt to set this property generates an error.
DBPROP_INIT_LCID SQLOLEDB validates the locale ID and returns an error if the locale ID is not supported or is not installed on the client machine.
DBPROP_INIT_LOCATION The name of an existing SQL Server. Data source initialization establishes a connection to the SQL Server on successful authentication of the user.
DBPROP_INIT_MODE SQLOLEDB supports read-only (DB_MODE_READ) and read/write (DB_MODE_READWRITE) access permissions for sessions created on an initialized data source.
DBPROP_INIT_PROMPT SQLOLEDB supports all prompting modes for data source initialization. SQLOLEDB uses DBPROMPT_NOPROMPT as its default setting for the property.
DBPROP_INIT_
PROTECTION_LEVEL
Not supported by SQLOLEDB. An attempt to set the property generates an error.
DBPROP_INIT_
PROVIDERSTRING
Ignored if set.
DBPROP_INIT_TIMEOUT SQLOLEDB returns an error on initialization if a connection to the SQL Server cannot be established within the number of seconds specified.

SQLOLEDB defines the following additional initialization properties.

Property ID Description
SSPROP_AUTH_
TRUSTEDCONNECTION
Type: VT_BOOL
R/W: R/W
Description: User authentication mode.

VARIANT_TRUE
SQLOLEDB uses Windows NT Authentication Mode to authorize user access to the SQL Server database specified by the DBPROP_INIT_LOCATION and DBPROP_INIT_DATASOURCE property values.

VARIANT_FALSE
Default
SQLOLEDB uses SQL Server Authentication Mode to authorize user access to the SQL Server database. The SQL Server login and password are specified in the DBPROP_AUTH_USERID and DBPROP_AUTH_PASSWORD properties.
SSPROP_INIT_APPNAME Type: VT_BSTR
R/W: R/W
Description: The client application name.
SSPROP_INIT_
AUTOTRANSLATE
Type: VT_BOOL
R/W: R/W
Description: OEM/ANSI character conversion.

VARIANT_TRUE
Default
SQLOLEDB performs OEM/ANSI character conversion when multibyte character strings are retrieved from, or sent to, the SQL Server.

VARIANT_FALSE
SQLOLEDB does not perform OEM/ANSI character conversion on multibyte character string data.
SSPROP_INIT_
CURRENTLANGUAGE
Type: VT_BSTR
R/W: R/W
Description: A SQL Server language name.

Identifies the language used for system message selection and formatting. The language must be installed on the SQL Server or data source initialization fails.
SSPROP_INIT_
NETWORKADDRESS
Type: VT_BSTR
R/W: R/W
Description: The network address of the SQL Server specified by the DBPROP_INIT_
LOCATION property.
SSPROP_INIT_
NETWORKLIBRARY
Type: VT_BSTR
R/W: R/W
Description: The name of the Net-Library (DLL) used to communicate with the SQL Server. The name should not include the path or the .dll file name extension.

The default is provided by the SQL Server client configuration.
SSPROP_INIT_PACKETSIZE Type: VT_I4
R/W: R/W
Description: A network packet size in bytes. The packet size property value must be between 512 and 32767. The default SQLOLEDB network packet size is 4096.
SSPROP_INIT_
USEPROCFORPREP
Type: VT_I4
R/W: R/W
Description: SQL Server stored procedure use.

Defines the use of SQL Server temporary stored procedures to support the ICommandPrepare interface.

SSPROPVAL_USEPROCFORPREP_OFF
A temporary stored procedure is not created when a command is prepared.

SSPROPVAL_USEPROCFORPREP_ON
Default
A temporary stored procedure is created when a command is prepared. The temporary stored procedures are dropped when the session is released.

SSPROPVAL_ USEPROCFORPREP_ON_
DROP
A temporary stored procedure is created when a command is prepared. The procedure is dropped when the command is unprepared with ICommandPrepare::Unprepare, or when a new command is specified for the command object with ICommandText::SetCommandText, or when all application references to the command are released.
SSPROP_INIT_WSID Type: VT_BSTR
R/W: R/W
Description: A string identifying the workstation.