INFO: ??????? ????????? ??? ???? ????? ODBC

?????? ????????? ?????? ?????????
???? ???????: 169470 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

???? ??? ?????? ??? ??????? ?????? ????????? ??? ???? ????????? ODBC.

??????? ????

  1. Q. ?? ?? ????? ODBC ???? ?

    ? ???? ????????? ?? ???? ??????? ??????? ??????? ?? 3.0 ODBC. ????? ???? ?????? ??? ??????? ODBC ????? ??????? ????? ?? ???? ???????. ????? ????? ????? ????? ?? ???? ODBC ??????? ???? ????? ??????? ??? ?????? ??????? ?? ?????? ??????? ???? ??? ???? (henv) ???? ????? ????? ????? ?????. ??? ???? ????? ????? ??? ????? ??? henv ?????? ?? ????? ????? ??????.
  2. Q. ?? ?????? ??????? ???? ?? 2.x ????? ????? ODBC ?????????

    ? ??? ????? ???? ????????? ODBC ?????? ????? ????? ??????? 3.0 ?? ??????. ?? ??? ????? ?????? ???????.
  3. Q. ???? ????? ????? ??????? ?? ?????? ????? Microsoft Access ??? ????? ??????? ??? ????? ?? ????? ?????? ????? ?

    ? ????? ????? ????? ??????? ?? Microsoft Access ?????? ???????. ?????? Microsoft Access Jet ? Jet ?? ?????? ????? ???????? ?? Jet 4.0. ?? MDAC 2.1 ?????????? ??????? ????? ??? ???? ????????? ?? ODBC Access ?????? ???????.
  4. Q. ??? ??? ????? ????? ??????? ?? ODBC ??????? ?

    ???? ????? ODBC A. ??????? SQLSetEnvAttr ?????? SQL_ATTR_CONNECTION_POOLING ????? ????? ???????. ????? ?? ????????? ??? ????? ????? ???? ?? ??? ??????? ODBC ????????? ?????? ?????? ??????? ??????? ?? "????? ??????? ?? Microsoft:
    164221????? ????? ????? ??????? ?? ????? ODBC
  5. Q. ??? ?????? ????? ????? ??????? ??? ????? ??????? ?? Visual Basic

    ???? ? ????? Visual Basic ?? ODBC ??????? ?????? SQLSetEnvAttr ????? ????? ???????. ????? ???? ??? ????? ??????? ???? ???? ??????? ?? ????? ??????? ???? ??? ?? ???? ????? ????? ????? ODBC ?? ????? Visual Basic ????? ?????????. ???? ?????? Visual Basic ?? ??????? ????? ?????? ?????????? ???????? ?????? ????? ?????????.
          Declare Function SQLSetEnvAttr Lib "odbc32.dll" (ByVal henv As Long,
          ByVal Attribute As Long, ByVal Value As Long, ByVal StringLength As
          Long) As Integer
    
          ' env attribute
          Public Const SQL_ATTR_CONNECTION_POOLING = 201
          Public Const SQL_ATTR_CP_MATCH = 202
    
          ' values for SQL_ATTR_CONNECTION_POOLING
          Public Const SQL_CP_ONE_PER_DRIVER = 1
          Public Const SQL_IS_UINTEGER = -5
    
          nstatus = SQLSetEnvAttr(0, SQL_ATTR_CONNECTION_POOLING,
          SQL_CP_ONE_PER_DRIVER, SQL_IS_UINTEGER)
          SQLAllocEnv...
          SQLAllocConnect...
          SQLConnect...
          SQLDisConnect...
          SQLFreeConnect...
          SQLFreeEnv...
    					
    ?????? ??? ??????? ??????? ???? ??? ???? ????????? ????????? ??????? ?? "????? ??????? ?? Microsoft:
    237844HOWTO: ????? ???? ????? ODBC ?? ????? ADO VB
    228843HOWTO: ???? ????? ???? ??? ?? ?????? ADO Visual Basic
  6. Q. ??? ??? ????? ????? ??????? ?? OLE DB ??????? ?

    ???? ??????? ????? ? OLE DB SQLSetEnvAttr ????? ????? ???????.

    ????? ?? ????????? ??? ????? ????? ????? ??????? ?? ????? OLE DB ?????? ?????? ??????? ??????? ?? "????? ??????? ?? Microsoft:
    166083????? ????? ????? ??????? ?? ????? OLE DB
  7. Q. ??? ??? ????? ????? ??????? Active Server Pages (ASP) ?? ?????? ?????? ActiveX (ADO) ?

    ???? "? ??????? Microsoft ??? ??????" (IIS) ??????? 3.0 ?? "????? ?????? ??????" ?????? ?? ???? ?????????. ????? ????? ???? IIS ?????????? ?? ???? ????? ???? StartConnectionPool ??? 1 ?????????. ??? ?? StartConnectionPool ??? HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\W3SVC\ASP \Parameters.
  8. Q. ????? ????? ??? ????????? ?? ??????

    ? ??? ?????? ??? ????????? ?? ?????? ??? ODBC ????? ?????? ?????. ?? ???? ??????? ?? ??????? ODBC.
  9. Q. ???? ???????? ??? ??????? ?? ?????? ?

    ? ????? ?????? ????????? ?? ????? ???????.?????? ??? ??????? ??????? ???? ??? ???? ????????? ????????? ??????? ?? "????? ??????? ?? Microsoft:
    216950????? ????? ????? ODBC ???? ?????? ??????
    238442????? ???? ???? ????? ODBC ?? PerfMon
    245543INFO: ????? ODBC ???? ?????? ?? ?????? ??????
  10. Q. ??? ???? ?? ?????? ????? ???? ????????? ?? ?????? ?

    ? ???? ????? ????? ?? ?????? ????? ??? ????? CPTimeout ?????? ????? ODBC. ???? ?????? ?????? ?????? ???? ????? ??????? ???????? ????? ?? ??????. ???? ??????? ??????? ODBC SQLConfigDriver ?????? ?????? CPTimeout ????? ??? ?????? ?? ???? ????????? ODBC ???? ?????? ?????? ????? ODBC ??????. ?????? ?????????? CPTimeout 60 ?????.
  11. Q. ?? ???? ???? ???? ????? ????? ??????? ?? ???? ????? ??????? ????? ?? ?? Microsoft Server ?????????

    ? ??? ???????? ???? ?????? ????? ODBC ??? ???? ?????? ODBC Microsoft Server ????????? ??? ????? ????? ???????; ?? ???? ?????? ???? ????????? ???? ????.
  12. Q. ???? ?? ????? ????? ?? ?????? ??? ???? ? ??? ODBC ?? ????? ?????? ????? ???? ?????? ??? ????? ?? ??? ?

    ? 3.0 ODBC hands ??? ????? ??? ???? ???? ?????? ?? ?? ??? ??? ??????? ??? ???? ?? ??. ?? Service Pack 1 ? ????? ????? ?????? ????? ????? ??? ????. ?? ???? ??? ????? ????? ?? ?????? ??? ????? ?????? ????? ????? ?? ???? ??????? ????? ???. ??? ?? ??? ?????? ??? ????? ????? ??? ????? ?????? ????? ??? ????? ????? ???.
  13. Q. ?? ODBC 3.0 Service Pack 1? ????? ?????? ????? ODBC ????? ??????? ????? ????? ???????? ???? ????? ??? ??? ???? ?????? ?

    ? ????? ???? ?????? Service Pack 1 ?????? ?? ODBC 3.0 ??? ???? API? ODBCSetTryWaitValue ? ???? ????? ?????? ????? ODBC ?? ??????? ????? ??? ????? ???? ?????. ???? ????? DWORD ODBCSetTryWaitValue ?? ??? ????????? ???????? ?? ????? ?? ?????? ??????:
    HKEY_LOCAL_MACHINE\Software\Odbc\Odbcinst.ini ?????? ????? Pooling\Retry \ODBC
    ????? ????? diver ?????? ?? ???? ????? ?????? ?????, ????? ????? ??? ???? ????? ??? ??????? ?? ?????. ?? ??? ?????? ??? ????? ?????? ???? RetryWait ????? ????? ?????? ????? ??? ??? ?????? ????? ??????? ????? ????? ????????.

    ????? ?? ????????? ??? ????? ??????? ODBCSetTryWaitValue ODBC API ???? ??????? ??????? ?? "????? ??????? ?? Microsoft:
    168250Degrades ?????? IIS ?? ????? ????

?????

????? ?? ????????? ??? ???? ????????? ???? ???? ???? ???? Microsoft ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms810829.aspx

???????

???? ???????: 169470 - ????? ??? ??????: 27/????/1428 - ??????: 3.3
????? ???
  • Microsoft Open Database Connectivity 3.0
  • Microsoft Data Access Components 1.5
  • Microsoft Data Access Components 2.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
????? ??????: 
kbmt kbdatabase kbgrpdsmdac kbgrpdsvcdb kbinfo kbmdac250 kbmdac260 kbmdac270 kbodbc kboledb kbusage kbvbp KB169470 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????169470

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

 

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