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