Share via


ResourceProps Table

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The ResourceProps table stores the actual resource property values. Together with the Resources, SiteResources, and Sites tables, this table stores the data for the Administration database.

The following table describes the columns of the ResourceProps table.

Note

Do not modify the definition of this table for any reason. It is described here for reference.

Column

Description

i_ResourceID

An integer that identifies the resource with which this property is associated. Values in this column correspond to the values in the i_ResourceID columns in the pupdbscript, Resources, and SiteResources tables.

s_PropertyName

Set to an arbitrary string that serves as the internal name of the property, and is used when you access the property programmatically with the GlobalConfigFreeThreaded, GlobalConfig2FreeThreaded, SiteConfigFreeThreaded, and SiteConfigReadOnlyFreeThreaded objects.

Typically, this name is descriptive and starts with a letter that indicates the data type of the property and an underscore. For example, "i_RetryInterval" indicates an integer data type.

f_IsConnStr

When set to "1", indicates that the property is an OLE DB connection string. If set, Commerce Server Manager uses a Universal Data Link (UDL) dialog box to set the value, and Commerce Server Site Packager will prompt for connect information for a specific database when unpacking.

See the note later in this topic for more information about this flag and its relationship to connection string configuration values.

f_IsHidden

When set to "1", the Generic Resource dialog box will not display the property. Set this flag to "1" for properties for which there is a custom MMC snap-in.

f_IsSimpleList

When set to "1", indicates that the new property is a SimpleList object. This feature enables the storage of multivalued properties.

s_Description

This column is not used.

i_Vartype

An integer that indicates the Variant type of the data being stored. For example, 8 indicates a string and 8200 indicates an array of strings. All Variant types except SafeArray, IUnknown, and IDispatch are allowed.

s_Value

The value of the property.

s_DisplayName

A user-friendly display name for the property that is shown in the Generic Resource dialog box.

Note

Commerce Server Site Packager performs special processing for resource properties that have names that start with "connstr_db". The values associated with these properties are packaged, but when they are unpacked, the packaged value is ignored and they are provided with default connection string values. If you decide to perform quick unpacking, these defaults are automatically accepted. If you decide custom unpacking, the defaults are displayed and you can change them. Even though they are ignored during unpacking, these connection strings are packaged in clear text, exposing them as a potential security risk.

The packaging of connection string values presents a potential security risk because the value is stored as clear text in the site package. This includes any password. The following mechanism has been developed to avoid this security risk.

See Also

Other Resources

ExtendedProps Table

Resources Table

SiteResources Table

Sites Table

SystemProps Table

Resource Tables in the Administration Database