????? ????? ????? IIS ODBC

?????? ????????? ?????? ?????????
???? ???????: 245243 - ??? ???????? ???? ????? ????? ??? ???????.
???? ???? ????? ?????????? ??????? ??? Microsoft ????? ??????? ?????? (IIS) ??????? 7.0 ????? Microsoft Windows Server 2008. IIS 7.0 ????? ???? ?????? ??????? ??? ???? ?????. ????? ?? ????????? ??? ???????? ??? ????? ??????? IIS ?? ?????? ???? Microsoft ?????? ??? ?????:
http://www.microsoft.com/technet/security/prodtech/IIS.mspx
????? ?? ????????? ??? IIS 7.0 ?? ?????? ???? Microsoft ?????? ??? ?????:
http://www.iis.net/default.aspx?tabid=1
????? ???? | ?? ????

?? ??? ??????

??????

?? 4.0 ?? ???? ??????? ?????? (IIS) "?" ?? 5.0 ?? ????? ??????? ?????? (IIS) ? ? "?? ????? ??????? ?????? (IIS) 6.0" ? ????? ????? ???? ????? ????? ????? ???????? ??????? (ODBC) ?????? ????? ??? ????? ?????? Microsoft Access ?????? ?? ????? ?????? Microsoft SQL Server ??????? ?? ???????.

????? ????

????? ???? ?? ????? ?????? Microsoft Access ?? SQL Server. ?????? ????? ???? ??????? ?? ????? "Run a SQL Script to Automate Creating the Table ?? ????? ???? ?????? ???????? ?????? ?? ?????? Table - Field Format. ?? ??? ?????? ????????? InternetLog ??? ???? ????? ????? ODBC ?? ???? ?????? ???????? ????? ????? ?????? (ISM) Microsoft (MMC).

??????: ???? ??? ??????? ???????? (WWW) ?? ???????? ??? ??????? (FTP) ????? ?????? ???? ???.

????? ?????? ??? SQL ?????? ????? ????

??? ??? ?????? ???? ??????? ???? ????? ??????? SQL Server ? ????? ????? ???? ????? IIS ODBC ?? ?????? ??? SQL ???????? ?????? Logtemp.sql ??????? ?? IIS. ?????? ????? ???? ??????? ???????:
  1. ?? ?????? ?????? ??? ?????? ???????? ???? ?????? ?? ?? ?????? ??????? ??? ??????? ???? ????? ??????? SQL Server.
  2. ???? ???? ??????? ???? SQL.
  3. ?? ??????? ???? ???? ??? ???.
  4. ??? ???? ?????? %Windir%\System32\Inetsrv.
  5. ???? ??? Logtemp.sql ?? ???? ??? ???.
  6. ?? ????? ????? ?? ???????? ????? Logtemp.sql ?????? inetlogInternetLog.
  7. ??? ????? ???????? ?????? ???? InternetLog. ???? ???????? ???? ????? ???????? ???????? ??? Microsoft ?? ???? ??????? ????? ???????? ???.
  8. ???? ??? ??????? ?? ???? ??? ?????.

???? - ????? ???

FieldName: ClientHost
Data Source/Type: Varchar(255)
Explanations: Client IP address.

FieldName: Username
Data Source/Type: Varchar(255)
Explanations: User name for the client. If the page is not password-protected, this is always the anonymous user name.

FieldName: LogTime
Data Source/Type: Datetime
Explanations: Date and time that the log entry was created.

FieldName: Service
Data Source/Type: Varchar(255)
Explanations: Name of the service. This can be WWW, FTP, or some other name.

FieldName: Machine
Data Source/Type: Varchar(255)
Explanations: Server name.

FieldName: ServerIP
Data Source/Type: Varchar(255)
Explanations: Server IP address.

FieldName: ProcessingTime
Data Source/Type: Int
Explanations: Time spent on request processing (in milliseconds).

FieldName: BytesRecvd
Data Source/Type: Int
Explanations: Number of bytes received.

FieldName: BytesSent
Data Source/Type: Int
Explanations: Number of bytes sent.

FieldName: ServiceStatus
Data Source/Type: Int
Explanations: Service status, such as 200.

FieldName: Win32Status
Data Source/Type: Long Integer
Explanations: Windows NT status code. 0 typically indicates success.

FieldName: Operation
Data Source/Type: Varchar(255)
Explanations: Type of the operation or command. For example, this may be USER for FTP or GET for WWW.

FieldName: Target
Data Source/Type: Varchar(255)
Explanations: Target of the operation. For example, this may be Default.htm.

FieldName: Parameters
Data Source/Type: Varchar(255)
Explanations: Any parameters for the operation. This can be either name/value pairs for invoking CGI or an ISAPI extension. It is a user name for the FTP command USER.

????? ???? DSN

??????: ?????? ??? ?????? SQL Server 7.0.
  1. ??? ????????? IIS ???? "???? ??????" ???? ????? ??????? ??? ???? ?????? ODBC ? ???? ??? ????? ??????? ???? DSN ?? ?? ???? ??? ?????.
  2. ????? ???? ???? "???? ?????? ????" ? ???? ?????? ???? SQL ?? ???? ??? ?????.
  3. ?? ?????? ??? ???? HTTPLOG ? ???? ????? ???? ?????? ???? SQL ???? ???? ??????? ?? ?? ???? ??? ??????. ??? ??? ???? SQL ??? ??? ???? ?????????, ??? (??????).
  4. ?? ????? "?????" ? ???? ?? ????? ?????? ?????? ?? Windows NT ???????? ???? ????? ?????? ???? ??????? ????????? ???? ???? ?????? SQL Server. ??? ????? ?????? ?? ??????? ??????? ????????? ?????? ??????? ???????. ???? ?? ??? ??? ???? SQL ??? ?? ???? ??? ?????.
  5. ???? ??? ??????.
  6. ????? ????? ???????? ?????????? ??? ????? ???????? ??? ???? ???? ???? ?? ???? ??? ??????.
  7. ??? ???? ???, ????? ????? ??? ????? ??? ????????? ??? ??? ??? ??????? ????? ???? ???????? ?????? ????? ODBC ??? ??? ??? ????? ?? ???????.
  8. ???? ??? ?????.
  9. ?? ????? ??????? ???? ??? "?????? ???? ????????". ???? ?? ?? ????? ??????? ??? ???? ??????? ???? ????? ??????? SQL Server ?? ?? ????? ??? "?????" ???????.

????? IIS ?? ??? ????? ODBC


  1. ?? MMC ISM ???? ??? ?????? ?????? ??? ???? ??? ?? ???? ??? ?????.
  2. ???? ??? ????? ??????? ???? ???.
  3. ?? ??????? ????? ????? Active Directory ? ???? ?????? ????? ODBC. ????? ????? ??? ???????? ????? ?????? ?? ???? ????? ????? ODBC ??? ???? ?????? Windows NT ???????? ??? ????? ???? DSN ?? ?????? ??? ??????? ???? ????? ??????? SQL Server.
  4. ???? ??? ????? ??? ?? ???? ??? ?????. ??????: ??? ????? ???? ??? ???? ????? ????? ODBC ??? ??? ???????? ?? ???? ???? SQL ????? ?? ????? ??? ???? (-). ??? ?? ??????? ???? ???? ???? ??? ?????? ?? ???? ????? ???? SQL.

  5. : ??? ?? ????? ???? ??? ???? ????? ????? ODBC ?? ISM MMC, ???? ??? ?????? ?????? ??? ???? ??? ?? ???? ??? "?????" ?????? ????? ??? ???.
  6. : ??? ?? ????? ???? ??? ????? ????? ODBC ???? ???? ???? ???? ??? ?????? ?????? ?? ???? ??? "????" ?????? ????? ???? ??? ????? ??.

?????? ????? ODBC

  • ?? ???? Microsoft ????? IIS ??? ???? ???? SQL ??? ??? ????????? IIS ???? ???????. ????? ????? ???????? ??? ????? ?????? SQL Server ????? ??? ????? ?????? ????? ??????. ?? ??? ??????? ???? ???? ??????? ????? IIS ??? ????? ???? ???.?????? ??? ???? ?? ????????? ??? ??????? ????? IIS ??? SQL ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
    296085????? ??????? SQL Server ?????? ????? ???
    296093?????? ???????? PrepWebLog ?????? IIS ????? SQL ????? ????? ?????
  • ???? ???????? ?????? ????? ??????? ????? ????? SQL Server. ??? ??? ?????? ??????? ???? ???? ?????? SQL Server ? ?? ???? ????? TCP/IP ?? ??? ????? SQL Server.

??????? ??????? ????????

??? ?? ??? ????? ?????? InternetLog ???? ???? ?? ??? ?? ??? ??? ???????? ??????? ???????? ??????? ??? ???? InternetLog ?? ????? ??? ??? ???? 5 ?? 6 ????? ????? (?? ???? IISLOG) ?? ?? ?????? ?? ??? ?????? "???? ???????".

??????: ?? ????? ????? ???????? ?????? ???? ??? ????? ???? DSN ???? ?????? ???? ????? ??? ???? ??????? ?????? ??????? ?????? ? ? ?? ???? ??????? ?? Configuring IIS for ODBC Logging ????? ???????.

?????

?????? ??? ???? ?? ????????? ??? ?????? ??????? ODBC ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
149398??? ????? IIS ??? SQL Server ?? ????? ??? ???????? ????? ??????
192293???? IIS ODBC ??????? ??? ??? ??????? ?? ???? SQL
256839??? ????? ????? URL ?? ?????? ????? ??? ??????? ODBC ???????
?????? ??? ???? ?? ????????? ??? ??????? ????? IIS ??? SQL ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
296085????? ??????? SQL Server ?????? ????? ???
296093?????? ???????? PrepWebLog ?????? IIS ????? SQL ????? ????? ?????

???????

???? ???????: 245243 - ????? ??? ??????: 04/???/1429 - ??????: 6.1
????? ???
  • Microsoft Internet Information Server 4.0
  • Microsoft Internet Information Services 5.0
  • Microsoft Internet Information Services 6.0
????? ??????: 
kbmt kbhowtomaster KB245243 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????245243

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com