FIX: ??????? ??? Four-part ????? ??? ????? where ?? ???? ???? ??? ???? ????? ?? SQL Server ???? ?????? ???? OLE DB ? DB2 ??????? ????? DB2

?????? ????????? ?????? ?????????
???? ???????: 2464256 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

????? ??? ??????? ???? ??? ?????? ??????:
  • Microsoft OLE Db ? DB2 3.0

???????

?? ???? ???????? ????????? ??????:
  • ??? ????? ???? Microsoft OLE DB ? DB2 ??? ???? ???????.
  • ???? ???? Microsoft SQL Server ????? ???? ???????? ???? OLE DB ? DB2 ??????? ????? ?? ?????? IBM DB2.
  • ????? ??????? ???? ????? ?? SQL Server. ????????? ?????? ???? ???? ??? four-part ? a???????? ????????? ?? ????? ??? DB2 ??????? ????? ????? ?????? IBM DB2.
?? ??? ?????????? ?? ???? ????????? ????.

???????? ???? ???? ??? ??????? ?? ???? ??? ??????? ????????? ????????? ?? ??? ????? DB2.

?????

???? ??? ??????? ???? ?? ?????? ???? OLE DB ? DB2?????????? ????? * ??< ?="">???????.

????? ????? ?????? ?????? ??? ??????? ??????? ???? ????????? * ??< ?="">????. ???? ????? ??????? ?????? (???)OpenRowset??????? ?? ??? ???? OLE DB ? DB2 ?????? ??? ??????? ?????? ??????? ??? four-part. "OpenRowset??????? ??????DBPROP_MAXROWS?????. ????? ????? ???? ??? ?????DBPROP_MAXROWS??????? ???? ?? ???? ?????? ???? ??? ??????? ?? ?????????. ??? ????? ?? ???? ?????? ???? OLE DB ? DB2DBPROP_MAXROWS???????? ?????????????? ????? ???? ????? * ??< ?="">??????? ??? ?????? ??? ????? ?????? IBM DB2. ?????? ???? ?? ???? ????? ?????? ????? ????????? ??? DB2??? * ??< ?=""> ????????? ????.

????

????? ???? ??? ?????? ????? Microsoft OLE DB ? DB2 2.0 ?????.

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

????? ????? ???? ????? ?? Microsoft. ??? ???? ??????? ??? ????????? ???????? ??? ?? ??????? ???????? ?? ??? ??????? ???. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??????? ???????? ?? ??? ???????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ????? ??? ?? ??? ????? ??? ??????? ?????? ???? ???????? ??? ????? ??????? ?????? ???? ????? ??? ??? ??????? ??????.

??? ??? ????? ??????? ?????? ???????? ???? ??? "???? ????? ??????? ????" ???? ????? ????? ??????? ?. ??? ?? ???? ??? ??????, ???? ???? ??????? Microsoft ?????? ?????? ??? ??????? ??????.

???????? ???? ???? ????? ?????? ?? ??????? ??? ?????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ??? ????? ????? ?? ????? ?????? ???? ??????? Microsoft ?????? ?? ?????? ??? ???? ?????? ?? ?????? ???? Microsoft ?????? ??? ???:
http://support.microsoft.com/contactus/?ws=support
?????????? ??????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ???? ?? ????? ????? ???? ???? ?????.

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

  • ?????? ??????? ?????? ????? Microsoft OLE DB ? DB2 1.0? ??? ?? ???? ???? ???? OLE DB ? DB2 1.0 Service Pack 1 (SP1) ????.
  • ?????? ??????? ?????? ????? Microsoft OLE DB ? DB2 3.0? ??? ?? ???? ???? ???? OLE DB ? DB2 3.0 ?????.
  • ?????? ??????? ?????? ???? 2009 ?? ???? ????? ?????? Microsoft? ??? ?? ???? ??? 2009 ???? ????? ?????? ?????.
  • ?????? ??????? ?????? ? 2010 ???? ????? ?????? Microsoft? ??? ???? ????? ?????? ????? Server 2010.

???????

  • ??? ????? ???? OLE DB ? 1.0 DB2 ???? ?????? SP1 ?? Microsoft SQL Server 2005 ???? Pack. ?????? ???? ???? 2005 ???? SQL? ?? ?????? ???? Microsoft ?????? ??? ???:
    ????? ??????? ??? Microsoft SQL Server 2005 ???? Pack (?????? 2007)
  • ??? ????? ???? OLE DB ? DB2 3.0 ?? ???? ????? Microsoft SQL Server 2008 R2. ?????? SQL Server 2008 R2 ?????? Pack, ?????? ???? Microsoft ?????? ??? ???
    ????? ??????? ??? ???? ????? Microsoft SQL Server 2008 R2

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

?? ???? ????? ????? ????? ????????? ??? ????? ??? ??????? ??????.

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

?? ?????? ??? ??????? ??????? ?? ????????? ???????? ??????.

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

????? ??????? ????????? ?? ??? ??????? ?????? ??? ???? ????? (?? ???? ??????? ??????) ???????? ?? ?????? ??????. ???????? ???????? ???? ??????? ??? ??? ?? "??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? UTC ???????? ??????? ????????????? ????????? ??????????? ???????????? ?? "???? ??????".
??????? ????? ????? ???????? ??? x86 ????????? x ?? ???? OLE DB ? DB2 1.0
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ??????????????????????? ???????????? ???? ??????
Db2oledb.dll7.0.3068.0520,01630-??????-201022: 46x 86???? ?????? SP2
Microsoft.hostintegration.dataaccesslibrary.dll7.0.3068.02,553,75230-??????-201022: 46x 86???? ?????? SP2
Microsoft.hostintegration.dataaccesstool.exe7.0.3068.0616,33630-??????-201022: 46x 86???? ?????? SP2
Mseidrda.dll7.0.3068.0805,20030-??????-201022: 46x 86???? ?????? SP2
Snanls.dll7.0.3068.0104,27230-??????-201022: 46x 86???? ?????? SP2
Trnsbidi.dll7.0.3068.059,72830-??????-201022: 46x 86???? ?????? SP2
????? ????????? ???????? ??? x64 ?? ???? OLE DB ? DB2 1.0
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ??????????????????????? ???????????? ???? ????????? ??????
Db2oledb.dll7.0.3068.0765,26418-??????-201000: 26x 64???? ?????? SP2??? ???? ???????
Microsoft.hostintegration.dataaccesslibrary.dll7.0.3068.02,549,65618-??????-201000: 26x 64???? ?????? SP2??? ???? ???????
Microsoft.hostintegration.dataaccesstool.exe7.0.3068.0612,24018-??????-201000: 26x 64???? ?????? SP2??? ???? ???????
Mseidrda.dll7.0.3068.01,404,24018-??????-201000: 25x 64???? ?????? SP2??? ???? ???????
Snanls.dll7.0.3068.0127,82418-??????-201000: 26x 64???? ?????? SP2??? ???? ???????
Trnsbidi.dll7.0.3068.067,92018-??????-201000: 26x 64???? ?????? SP2??? ???? ???????
Db2oledb.dll7.0.3068.0520,01618-??????-201000: 26x 86?? ?????????
Mseidrda.dll7.0.3068.0805,20018-??????-201000: 25x 86?? ?????????
Snanls.dll7.0.3068.0104,27218-??????-201000: 25x 86?? ?????????
Trnsbidi.dll7.0.3068.059,72818-??????-201000: 26x 86?? ?????????
??????? ????? ????? ???????? ??? x86 ????????? x ?? ???? OLE DB ? DB2 3.0
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ??????????????????????? ???????
Db2oledb.dll8.0.4308.0628,56013-?????-201122: 30x 86
Microsoft.hostintegration.dataaccesslibrary.dll8.0.4308.0788,37613-?????-201122: 30x 86
Msdrda.dll8.0.4308.0898,89613-?????-201122: 30x 86
????? ????????? ???????? ??? x64 ?? ???? OLE DB ? DB2 3.0
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ??????????????????????? ?????????? ??????
Db2oledb.dll8.0.4308.0880,97613-?????-201122: 52x 64??? ???? ???????
Microsoft.hostintegration.dataaccesslibrary.dll8.0.4308.0788,37613-?????-201122: 52x 86??? ???? ???????
Msdrda.dll8.0.4308.01,548,62413-?????-201122: 52x 64??? ???? ???????
Db2oledb.dll8.0.4308.0628,56013-?????-201122: 30x 86??????
Msdrda.dll8.0.4308.0898,89613-?????-201122: 30x 86??????
??????? ????? ??????? ???????? ??? x64 IA ?? ???? OLE DB ? DB2 3.0
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ??????????????????????? ?????????? ??????
Db2oledb.dll8.0.4308.01,721,16813-?????-201123: 11IA 64??? ???? ???????
Microsoft.hostintegration.dataaccesslibrary.dll8.0.4308.0788,37613-?????-201123: 11x 86??? ???? ???????
Msdrda.dll8.0.4308.02,429,77613-?????-201123: 11IA 64??? ???? ???????
Db2oledb.dll8.0.4308.0628,56013-?????-201122: 30x 86??????
Msdrda.dll8.0.4308.0898,89613-?????-201122: 30x 86??????
??????? ????? ????? ???????? ??? x86 ????????? x ?? 2009 ???? ????? ??????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ??????????????????????? ???????
Db2oledb.dll8.0.3791.2540,49617-??????-201003: 05x 86
Drdaresync.exe8.0.3791.2478,04017-??????-201003: 05x 86
Microsoft.hostintegration.adapters.msdb2.management.dll8.0.3791.2407,47217-??????-201003: 05x 86
Microsoft.hostintegration.adapters.msdb2.runtime.dll8.0.3791.279,78417-??????-201003: 05x 86
Microsoft.hostintegration.dataaccesslibrary.dll8.0.3791.21,279,89617-??????-201003: 05x 86
Microsoft.hostintegration.msdb2client.dll8.0.3791.2239,50417-??????-201003: 05x 86
Msdrda.dll8.0.3791.2882,00017-??????-201003: 05x 86
Snanls.dll8.0.3791.2109,39217-??????-201003: 05x 86
????? ????????? ???????? ??? x64 ?? 2009 ???? ????? ??????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ??????????????????????? ?????????? ??????
Db2oledb.dll8.0.3791.2763,72817-??????-201003: 10x 64??? ???? ???????
Drdaresync.exe8.0.3791.2675,16017-??????-201003: 10x 64??? ???? ???????
Microsoft.hostintegration.adapters.msdb2.management.dll8.0.3791.2407,47217-??????-201003: 10x 86??? ???? ???????
Microsoft.hostintegration.adapters.msdb2.runtime.dll8.0.3791.279,78417-??????-201003: 10x 86??? ???? ???????
Microsoft.hostintegration.dataaccesslibrary.dll8.0.3791.21,279,89617-??????-201003: 10x 86??? ???? ???????
Microsoft.hostintegration.msdb2client.dll8.0.3791.2239,50417-??????-201003: 10x 86??? ???? ???????
Msdrda.dll8.0.3791.21,527,63217-??????-201003: 10x 64??? ???? ???????
Snanls.dll8.0.3791.2128,33617-??????-201003: 10x 64??? ???? ???????
Db2oledb.dll8.0.3791.2540,49617-??????-201003: 05x 86??????
Msdrda.dll8.0.3791.2882,00017-??????-201003: 05x 86??????
Snanls.dll8.0.3791.2109,39217-??????-201003: 05x 86??????
????? ????????? ???????? ??? x86 ?? ???? ??????? ?????? ????? Server 2010
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ??????????????????????? ???????
Db2oledb.dll8.5.4257.2640,84817-??????-201022: 58x 86
Drdaresync.exe8.5.4257.2530,26417-??????-201022: 58x 86
Microsoft.hostintegration.dataaccesslibrary.dll8.5.4257.21,300,37617-??????-201022: 58x 86
Microsoft.hostintegration.drdalink.dll8.5.4257.258,76017-??????-201022: 58x 86
Msdrda.dll8.5.4257.2976,72017-??????-201022: 58x 86
????? ????????? ???????? ??? x64 ?? ???? ??????? ?????? ????? Server 2010
?? ??? ??????????? ??? ??????
Db2oledb.dll8.5.4257.2898,38417-??????-201011:04 ?x 64
Drdaresync.exe8.5.4257.2717,65617-??????-201011:04 ?x 64
Microsoft.hostintegration.dataaccesslibrary.dll8.5.4257.21,300,37617-??????-201011:04 ?x 86
Microsoft.hostintegration.drdalink.dll8.5.4257.269,00017-??????-201011:04 ?x 64
Msdrda.dll8.5.4257.21,693,52017-??????-201011:04 ?x 64
??????????? ?????? ?????? ?? ????? ???? ????? ???? Host Integration Server ???? ????? ??? ??? ??????? ????? ??????.

?????

?? ????? Microsoft ?? ??? ?? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

???? ??????

??? ???? ??? ??? ???????, ??????OPENQUERY?????? ????? ?? ??? four-part ?? ?????????.

??? ???? ??????? ?? ??? ????? ????????? ??? ??? ????? ??????? ?????? ??? ???.

SELECT * FROM LINKED_SERVER.CATALOG1.SCHEMA1.DB2_VIEW WHERE COLUMN1 = '12345'
???? ??? ????????? ???? ???? ??? ???? ??????OPENQUERY???? ???? ???:
SELECT * FROM OPENQUERY(LINKED_SERVER, ?SELECT * FROM SCHEMA1.DB2_VIEW  WHERE COLUMN1 = '12345'?) 

??????? ????

??? ????? ??? ???????? ???? ?????? ??????? ???? ??????? ??? ??? ???? OLE DB ? DB2OpenRowset?????? ???? ??? ????? ????????DBPROP_MAXROWS:
SELECT * FROM tablename  FETCH FIRST nRows ROWS ONLY

??? ???DBPROP_MAXROWS?? ????? ??????? ???0? OLE "Db" ? DB2 ???? ????????? ?????? ?????? ??? ??????? ??????? ??? ???? ??? ????????? ????:

SELECT * FROM tablename
?????? ??? ?????? ???? ????? ??? ??????? ????? ?????? ?????? ?? Microsoft. ?? ???? Microsoft ?? ????? ???? ?????? ?? ?????? ????? ???? ?? ??????? ?? ??? ????????.

???????

???? ???????: 2464256 - ????? ??? ??????: 09/???? ??????/1432 - ??????: 2.0
????? ???
  • Microsoft OLE DB Provider for DB2 1.0
  • Microsoft OLE DB Provider for DB2 2.0
  • Microsoft Host Integration Server 2009
  • Microsoft Host Integration Server 2010
????? ??????: 
kbautohotfix kbqfe kbhotfixserver kbfix kbexpertiseadvanced kbsurveynew kbmt KB2464256 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2464256

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

 

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