Data Source Information Properties

更新日期: 2006 年 4 月 14 日

In the provider-specific property set DBPROPSET_SQLSERVERDATASOURCEINFO, the SQL Native Client OLE DB provider defines the following data source information properties.

Property ID Description

SSPROP_CHARACTERSET

Type: VT_BSTR R/W: R Default: NULL

Description: The character set in the server. Apply only to SQL Server 7.0 and earlier.

SSPROP_COLUMNLEVELCOLLATION

Type: VT_BOOL

R/W: Read

Default: VARIANT_TRUE

Description: Used to determine if column collation is supported.

VARIANT_TRUE: Column level collation is supported (in case of SQL Server 2000 and later)

VARIANT_FALSE: Column level collation is not supported.

SSPROP_CURRENTCOLLATION

Type: VT_BSTR R/W: R Default: NULL

Description: The current database collation name. Apply only to SQL Server 2000.

SSPROP_SORTORDER

Type: VT_BSTR R/W: R Default: NULL

Description: The sort order in the server. Apply only to SQL Server 7.0 and earlier.

SSPROP_UNICODELCID

Type: VT_I4 R/W: Read

Description: Unicode locale ID.

This is the locale used for Unicode data sorting.

SSPROP_UNICODECOMPARISONSTYLE

Type: VT_I4 R/W: Read

Description: Unicode comparison style.

The sorting options used for Unicode data sorting.

In the provider-specific property set DBPROPSET_SQLSERVERSTREAM, the SQL Native Client OLE DB provider defines the following additional property.

Property ID Description

SSPROP_STREAM_XMLROOT

Type: VT_BSTR R/W: Read/Write

Description: The result of a FOR XML query may not be a well-formed document. When this property is specified, the result of a ‘select … for XML’ query is wrapped in the root tag provided by this property to return a well formed XML document. If the query is executed in the browser it may cause the browser to display parser errors when loading the result. To avoid the error, SQL ISAPI supports the keyword ROOT. This keyword maps to SSPROP_STREAM_XMLROOT property.

请参阅

概念

Data Source Objects (OLE DB)

帮助和信息

获取 SQL Server 2005 帮助