IISODBC Input Format From-Entity Syntax

<from-entity>	::=	<SiteID> [ , <SiteID> ... ] | table:<tablename>;username:<username>;password:<password>;dsn:<dsn>
<SiteID>	::=	< site_number > < server_comment > < site_metabase_path >

The <from-entity> specified in queries using the IISODBC input format is either a comma-separated list of IIS Virtual Site "identifiers", or a single specification of the ODBC parameters needed to access the table.

"Site identifiers" must be enclosed within angle brackets (< and >), and can have one of the following values:

• The numeric site ID (e.g. "<1>", "<28163489>");
• The text value of the "ServerComment" property of the site (e.g. "<My External Site>", "<www.margiestravel.com>");
• The fully-qualified ADSI metabase path to the site (e.g. "<//MYSERVER/W3SVC/1>"), using either the numeric site ID or the text value of the "ServerComment" property of the site.

When a "site identifier" is used, the IISODBC input format connects to the specified machine's metabase, gathers information on the site's current ODBC logging properties, and uses this information to connect to the database table.

"Site identifiers" can also include wildcards (e.g. "<www.*.com>").

Examples:

FROM <1>, <2>, <My External Site>

FROM table:MYLOGTABLE;username:IISLOGUSER;password:IISLOGUSERPW;dsn:IISLOGDSN

---

© 2004 Microsoft Corporation. All rights reserved.