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

???? ?????? ???? ??????
???? ID: 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
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

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

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

Microsoft Access ?? SQL Server ??????? ??? ??? ?????? ??? ??? ??? ???? ?? ???, ?? ?? ????? ????????? ????? ?? ???????? ???? ?? ??? ??? SQL ????????? ???????????, ?? ??? ????? ?? ????? ?? ???????? ??? ?? ?? ?????? ??????????? - ????? ???????? ???????? ??????? ?????? ??? InternetLog ODBC ?????? ??? ????? ??? ??????? ???? ??????? (ISM) Microsoft ??????? ????? (MMC) ?? ???

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

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

??? ?? SQL ????? ?? ??? ?? ?? ???? ???????? ?? ????? ?? ??? ???, IIS ??? ????? ?? ?? Logtemp.sql ???? Transact SQL ????????? ?? ??? IIS ODBC ?????? ?????? ??? ???? ???? ??? ???? ?? ???, ????? ????? ?? ???? ????::
  1. ????? ?? SQL Server ??? ??? ???????? ?? ?????????? ????? ??? ?? ?? ?????????? ???? ?? ??? ?? ?????
  2. SQL ????? ?????? ???????? ??????
  3. ????? ???????????? ??,?????.
  4. %Windir%\System32\Inetsrv ??????? ?? ?????? ??????
  5. ????? ????,Logtemp.SQL?? ????-????? ????, ?? ???? ????????.
  6. Logtemp.sql ????????? ?? ???? ??????, ??? ?????inetlogwith:InternetLog.
  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??? ????? ????, ?? ???? ???add.
  2. ?? ??? ???? ????? ????? ????? ????? ???? ??, ?? ??? ???? ?? ??? ????? ????SQL ??????? ????-????? ????, ?? ???? ?????????.
  3. ????????????? ???,HTTPLOG, ????? ????? SQL ????? ?? ?????? ???? ????? ??? ?? ????? ?? ??? ????? ????, ?? ???? ???next. ??? SQL ????? ?? ?? ?? ???????? ??, ?? ??? ????(???????).
  4. ??????? ???????? ??? ????????? ???? ?? ?? ?? ??? ???? ?? ??? ????? ??????????? ????? ID ?? ????? ?? Windows NT ??????? ?? ??????????? ?? ??? ?? SQL ????? ?? ??? ??? ??????? ??????????? ?? ???? ????, ?? ??????? ?? ????? ????????? ??????????? ????????? ???? ?? SQL ????? ??? ??? ??, ?? ???? ??? ????? ????OK.
  5. ????? ????,next.
  6. ???? ???????? ?????? ?????, ?? ???? ??? ??????? ?? ??? ??????? ??????? ?? ??? ????next.
  7. ??? ?? ????? ???, ?? ?? ?? ??? ???? ?? ??? ????? ?? ???? ?????? ???? ?? ??? ?????? ???? ??? ??? ??????, ??ODBC ??????? ????? ??? ?? ???? ?? ??? ??? ???????? ????????
  8. ????? ????,??????.
  9. ???????? ?? ??? ??? ????? ???????? ????? ?? ??????? ????. ????????? ???? ?? ?? ?? ??? ??????????? ?????? SQL Server ??? ??? ???????? ?? ???, ?? ???? ??? ????? ????OK???? ?????? ???? ?? ????

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


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

  5. : ??? ??? ???? ODBC ?????? ??? ????? ?? ????????? ???? ??, ?? ISM MMC, ??? ???? ?? ????-????? ????, ?? ???? ???STOP:???? ??? ???? ?? ??? ?????
  6. : ??? ??? ???? ????????? ?? ODBC ?????? ??? ?????, Right-click ??? ????, ?? ???? ??? ????? ??????????????? ??? ???? ?? ???????? ???? ???? ?? ????

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

  • Microsoft IIS ???????? ??? ????? ?????? ?? ??? ??? SQL Server ?????? ?? ??? ?????? IIS ??????? ???? ????? ?????? ?????? consumes ?????? ??? ???? ?? ??? ??? SQL Server ??????? ?? ??? ?????? ???? ??? ??? ??? ?? ?????? ???, ?? ???? ?? ?? ??? ??? ???? SQL ??????? ?? ??? IIS ??? ?????IIS ??? ???? ?? ??? SQL ???? ???? ?? ???? ??? ???? ??????? ?? ??? ?????? ?? Microsoft ???????? ??? ????? ?? ??? ????? ???? ???????? ?? ????? ????:
    296085??? ?? ???????? ???? ?? ??? SQL ????? ?? ????? ???? ?? ??? ???? ??? ?? ???? ??
    296093PrepWebLog ?????? SQL ???? ?????? ???????? ???? ?? ??? IIS ??? ????? ????
  • ???????? ??? ??, ?????? ???????????? ????????????? ??????SQL ????? ??????? ?? ???? ??? ?? SQL ????? ?? ??? ?? ?? ?????? ???????? ?? ????? ?? ??? ???, ?? ???? SQL ????? ??????? ?? ???? TCP/IP ???????? ???? ?? ??? ?? ?? ???? ???

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

??? InternetLog ?????? ??? ?? ???????? ???? ???? ??? ??, ?? ??? ??? ?????????? ?? ???? ???? ??? ?? InternetLog ?????? ?? ??? ??? ?????????, ?? ???? ?? ???? ????? ID 5, ????? ID 6 (?? IISLOG ?? ?????), ?? ????? ????? ?????? ?? ?????? ??? ??? ???

???:: ???? ??????? ???????? ?? ???, ???? ?????? DSN ??????? ?? ?????? ?????? ?????? ?? ??? ??????? ????? ??? ???? ???? ?? ??? ???? ?????? ?? ???????? ????, ?? ?? ??? ??? ????? ?? ???? ????IIS ODBC ?????? ?? ??? ???????? ?????????? ??? ?????

??????

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

???

???? ID: 245243 - ????? ???????: 02 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft Internet Information Services 6.0
??????: 
kbhowtomaster kbmt KB245243 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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