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. |